question

ScottMacDonald-3222 avatar image
0 Votes"
ScottMacDonald-3222 asked ScottMacDonald-3222 commented

SSRS Solutions Issue

I'm having a very strange issue that I've never experienced in any development environment. Ever.

I am using Visual Studio 2019, Version 16.104.4 / Microsoft SQL Server Reporting Services Designers
Version 15.0.19528.0

I have a RDL file that was provided me. I can create the SharedDataSource, import the RDL (and redirect the DataSet to look at the new SharedDataSource), and Preview this "new" (to me) report no problem at all! It works nicely.

THEN - the SSRS Solution is saved. When you reopen it to run the report again (or work on it, whatever), I get an error when I try to Preview It:

"An error occurred during the local report processing.
Error in the application.
Object reference not set to an instance of an object."

It seems like the dataset somehow loses the connection to the SharedDataSource, but that's only a weak hypothesis.

Does anyone have any clue what is happening here?

Your help appreciated.

Thank you.

s

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered ScottMacDonald-3222 commented

Hi @ScottMacDonald-3222 ,
This error message indicates the object reference is not set to an instance of the object. It can be caused by one or more of the following reasons.

  • There are soft page breaks within empty lists in the report.

  • There are hidden groups within the report and you tried to export it to PDF.

  • The report has a link to a subreport that is not published on the report server and you tried to export it to CSV.

  • There are text boxes with a width and/or height of zero in the report.

  • A text box is either hidden or the NoRows property is set to true.

  • A text box spans table cells where some cells have a collection of null values.

  • The report has static columns and/or rows and, in the Visibility properties, Hidden is set to true.

  • The report has static columns and/or rows and there are grand totals in the report.

  • The report has static column headings and, in the Visibility properties, Hidden is set to true.

  • The matrix report has multiple columns and rows and, in the Visibility properties, Hidden is set to true and you tried to export to PDF or TIFF.

Please check it in your report. Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

While I appreciate your answer, it really doesn't explain why the project would be acceptable, and preview, before exiting/saving then reopening. Only then does this error occur. It leaves me wondering why then and not initially?

Again, your help is very much appreciated, but I'm looking for a needle in a haystack when looking at the list your provided.

Thank you.

0 Votes 0 ·