[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

SSRS Subreport in the table print in next page

I have a report that has a table and I have added a sub report to take the notes info from a different tables. When the report render and if the notes is more than 1 page it flows to a next page without a header info. I need to let the subreport use the page space in the main report.

Is it possible to control the subreport?
0
tvae
Asked:
tvae
  • 2
  • 2
1 Solution
 
planoczCommented:
the subreport normally runs right after the main table. So what do you mean by 'use the page space in the main report' ?
0
 
tvaeAuthor Commented:
the subreport has a lot of data and instead of it mixed in the header section it creates another page that just show the sub-report data.
0
 
planoczCommented:
that is what a sub report do. A sub report is a standalone report that is attached to your report. If you have to much data in your table then there is no room are the sub report. The sub report should be in a rectangle by itself. not in the table
0
 
tvaeAuthor Commented:
I will try to put it in a reactangle and see if it will put it in the empty space. What is happening is that i have jeader info then the sub report then the line detail . It ends up printing the header section and leave half of the page blank, then the data in the subreport falls on the 2nd page together with the line details.

What i need is the header section and part of the data of the subreport in the 1st page then the other half and the line details on the 2nd report.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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