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
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.
Thank you for the detailed response Anonymous. I was able to get the NoRowsMessage to appear when there are multiple subreports. Appreciate it!