Forum Discussion

jdc136's avatar
jdc136
Regular Visitor
1 year ago
Solved

SSRS Subreport not showing

I am using Microsoft SQL Server Reporting Services Version 15.0.1103.12 (i.e. SQL Server 2019 Reporting Services). I am creating a report using the standalone Report Builder (v15.0.20283.0). I am que...
SSRS
subreport
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, jdc136 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
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