Forum Discussion
SSRS Subreport not showing
Hi, jdc136
Thank you very much for your reply. Here are the full demo processes, you can try to follow them:
For the Sub1 report I set it up as follows:
For the Sub2 report I set it up as follows:
For the main report, I set the following:
It delivers the results you're looking for:
In order to be able to get multiple choices, I use the IN keyword in my query here. Also add a dataset Year to the main report:
Modify the year parameter of the main report as follows:
Here are the results:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, jdc136
Based on your description, I created the corresponding dataset and tablix:
Associate Year to Sub1 and Sub2:
Try previewing the report:
With regard to your later question, are you using a data source from a shared dataset?
Cache reports - SQL Server Reporting Services (SSRS) | Microsoft Learn
Cache shared datasets - SQL Server Reporting Services (SSRS) | Microsoft Learn
Try setting a timeout value for it:
To avoid caching issues, you can connect directly to your data source in a report and then create a report based on it.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thank you so much for replying to my issue!
First, you're not exactly reproducing what I have. You are using datasets within the main report whereas I am referencing wholly different reports, as described in the documentation for subreports.
Second, I played around a bit more, and it seems that there is an issue but I can work around it. I have two subreports:
@Year will default to the year of the current day, so for today that would be 2025. My subreports for today have associated data, and the subreports appear as expected:
If I change it to 2024, which is the year that was populating when I was testing this the other day, I get nothing:
However, if I click "View Report" again I get the NoRowsMessage for each subreport:
So the problem seems to lie in that NoRowsMessage does not appear for a subreport initially, when there is more than one subreport. I seem to be able to reproduce this consistently. Is this a known issue? Are you able to reproduce this behavior?
Hi, jdc136
Thank you very much for this information. First, I reproduced the error in your post:
Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessing+DataCacheUnavailableException' was thrown. ---------------------------- The data cache for the report edit session is not valid. Rerun the report to create a new and valid data cache. (rsDataCacheMismatch)Dynamic parameter :
I guess you applied this Dynamic parameter in the filter panel of the Main dataset, causing this issue.
You can do this by adding a Year dataset to each report:
The two subreports will display as expected:
Of course, when I select a data item that the main report has but the subreport doesn't, it causes the subreport query to fail, which is normal. This is because this value does not exist in the parameters of the subreport.
To solve this problem, we need to carry the parameters of the subreport in the query, not in the filter panel:
The primary dataset still needs to set an available value in order to pass it to the subreports.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thank you for getting back to me again! So for additional information, this is the setup I have. Here is what one of my subreports looks like:
You can see I have a parameter tied to a parameter in the "Main" dataset. The Tablix showing the results from the main dataset has a NoRowsMessage property entered.
If I enter the year "2024" for this particular report, I get the NoRowsMessage:
Here is the main report that contains a reference to this report as a subreport:
You can see that I have my report parameter and am passing it to the subreport parameter "TaxYear". When I run this report for 2024, as above, I do not see the NoRowsMessage like I do when I run the report on its own.
Reviewing your response, I have a few questions. What do you mean add a "year dataset to each report"? In your case, your dataset is using the filter panel, whereas mine is using a parameter, which is what you recommend a couple steps later ("carry the parameters of the subreport in the query, not in the filter panel"). My underlying SQL query is simply stating alias.year = :TaxYear, which differs slightly from what you have using an in operator.
When I remove the message from NoRowsMessage, I still get a "result", but it is empty. Again, this is when running the subreport on its own.
However, running the main report, again, I do not see an empty table - I see nothing at all, just blank space.
What I am expecting is that I can set NoRowsMessage in the tablix of my subreport, and if I get no rows returned from the query, I see my message both in the subreport itself and in the main report referencing the subreport.
Hi, jdc136
Thank you very much for your reply. Here are the full demo processes, you can try to follow them:
For the Sub1 report I set it up as follows:
For the Sub2 report I set it up as follows:
For the main report, I set the following:
It delivers the results you're looking for:
In order to be able to get multiple choices, I use the IN keyword in my query here. Also add a dataset Year to the main report:
Modify the year parameter of the main report as follows:
Here are the results:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.