Solved

SSRS Subreport in the table print in next page

Posted on 2011-03-22
5
569 Views
Last Modified: 2012-08-13
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
Comment
Question by:tvae
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 35194222
the subreport normally runs right after the main table. So what do you mean by 'use the page space in the main report' ?
0
 

Author Comment

by:tvae
ID: 35194397
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
 
LVL 27

Accepted Solution

by:
planocz earned 250 total points
ID: 35195192
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
 

Author Comment

by:tvae
ID: 35197747
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question