• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 867
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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