Solved

SSRS Subreport in the table print in next page

Posted on 2011-03-22
5
566 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
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…

809 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