[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SSRS Subreport in the table print in next page

Posted on 2011-03-22
5
Medium Priority
?
579 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 1000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

649 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