• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • Last Modified:

SSRS: Subreport should only show on the first page.

Hello,

I have an SSRS report which contains several sub reports.

I would like one of the sub reports to only appear on the first page of the report.

What is the best way of doing this?

Thanks!
0
OrbusLLC
Asked:
OrbusLLC
1 Solution
 
OrbusLLCAuthor Commented:
I'm responding to my own post because I have learned something. This will be obvious to some.

A report can contain a header, body and footer. The header and footer are parts which can be added to the report and behave differently than the body. For instance, the global page number variables are only available in the header and footer. Sub reports, however, are only allowed in the body.

Now, in my case, I had a tablix in the report body. There was a sub report in this tablix. The tablix was taking up the whole report body. I did not realize that I could put the sub report outside of the tablix and that was the solution to my problem.

So, my report now has a body which contains a sub report and, below that, a tablix. Things are now working exactly as intended.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now