Solved

SSRS Subreport in the table print in next page

Posted on 2011-03-22
5
567 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
  • 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 our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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