Surkot


I have a report that has one subreport. I am finding that if the entire content of the subreport will not fit within the space remaining on the page that it will not start displaying data from that subreport until the next page of the report, leaving a blank section in the report. I would like it to display as much as possible on the first page and then continue on subsequent pages.

Is there a way



Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

BobP - BIM


Are you on SSRS 2005 sp2

To check, go to http://server/reportserver and look at the bottom left of the page.

BobP







Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot

Yes. Here is the version number

9.00.3042.00





Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

?®€?§Q?

If it is a table or matrix, be sure to check "fit this table/matrix on one page if possible".

Also, I may have read at one point that expanding the report horizontally slightly may help with this. However, I may be dreaming that one up.






Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot

My subreport has tons of textboxes and one or two table items and my entire subreport is contained in a rectangle. (since I want to show/hide the subreport based on some conditions).








Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot


Any other ideas

I have created a very simple program to reproduce the problem. create a project and add three rdl files with names MainPage, SubPage1, SubPage2.

Here is the XML for each RDL file. Export it to PDF and observe that the SubPage2 starts in a fresh page instead of continuing in the previous page.

MainPage

< xml version="1.0" encoding="utf-8" >
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<rdBig SmilerawGrid>true</rdBig SmilerawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rdTongue TiednapToGrid>true</rdTongue TiednapToGrid>
<Body>
<ReportItems>
<Subreport Name="subreport2">
<Left>1in</Left>
<Top>0.5in</Top>
<ZIndex>1</ZIndex>
<Width>6in</Width>
<ReportName>SubPage2</ReportName>
<Height>0.25in</Height>
</Subreport>
<Subreport Name="subreport1">
<Left>1in</Left>
<Top>0.125in</Top>
<Width>6in</Width>
<ReportName>SubPage1</ReportName>
<Height>0.25in</Height>
</Subreport>
</ReportItems>
<Height>2.375in</Height>
</Body>
<PageHeader>
<ReportItems>
<Textbox Name="tmplName">
<Left>0.25in</Left>
<Top>0.125in</Top>
<Width>7.5in</Width>
<Style>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>16pt</FontSize>
<BackgroundColor>LightSteelBlue</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>Test Header</Value>
</Textbox>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageHeader>
<rd:ReportID>27945455-ce7b-4449-919c-771216f4ff66</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<Code />
<Width>8in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Textbox Name="textbox2">
<Left>3.375in</Left>
<Top>0.125in</Top>
<ZIndex>2</ZIndex>
<Width>3.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Globals!ExecutionTime</Value>
</Textbox>
<Textbox Name="textbox1">
<Left>6.5in</Left>
<Top>0.125in</Top>
<ZIndex>1</ZIndex>
<Width>1.375in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>="Page " &amp; Globals!PageNumber &amp; " of " &amp; Globals!TotalPages</Value>
</Textbox>
<Textbox Name="tmplReportName">
<Left>0.25in</Left>
<Top>0.125in</Top>
<Width>3.125in</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Globals!ReportName</Value>
</Textbox>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.25in</TopMargin>
</Report>


SubPage1

< xml version="1.0" encoding="utf-8" >
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<rdBig SmilerawGrid>true</rdBig SmilerawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rdTongue TiednapToGrid>true</rdTongue TiednapToGrid>
<Body>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox5">
<Top>4.375in</Top>
<ZIndex>7</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Sub Report1 - TextBox8</Value>
</Textbox>
<Textbox Name="textbox6">
<Top>3.75in</Top>
<ZIndex>6</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox7</Value>
</Textbox>
<Textbox Name="textbox7">
<Top>3.125in</Top>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox6</Value>
</Textbox>
<Textbox Name="textbox8">
<Top>2.5in</Top>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox5</Value>
</Textbox>
<Textbox Name="textbox4">
<Top>1.875in</Top>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox4</Value>
</Textbox>
<Textbox Name="textbox2">
<Top>1.25in</Top>
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox3</Value>
</Textbox>
<Textbox Name="textbox1">
<Top>0.625in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1- TextBox2</Value>
</Textbox>
<Textbox Name="textbox3">
<rdBig SmileefaultName>textbox3</rdBig SmileefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report1 - TextBox1</Value>
</Textbox>
</ReportItems>
</Rectangle>
</ReportItems>
<Height>4.875in</Height>
</Body>
<rd:ReportID>27945455-ce7b-4449-919c-771216f4ff66</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<Code />
<Width>6in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>0.25in</TopMargin>
</Report>

SubPage2

< xml version="1.0" encoding="utf-8" >
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<rdBig SmilerawGrid>true</rdBig SmilerawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rdTongue TiednapToGrid>true</rdTongue TiednapToGrid>
<Body>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox5">
<Top>4.375in</Top>
<ZIndex>7</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Sub Report2 - TextBox16</Value>
</Textbox>
<Textbox Name="textbox6">
<Top>3.75in</Top>
<ZIndex>6</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox15</Value>
</Textbox>
<Textbox Name="textbox7">
<Top>3.125in</Top>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox14</Value>
</Textbox>
<Textbox Name="textbox8">
<Top>2.5in</Top>
<ZIndex>4</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox13</Value>
</Textbox>
<Textbox Name="textbox4">
<Top>1.875in</Top>
<ZIndex>3</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox12</Value>
</Textbox>
<Textbox Name="textbox2">
<Top>1.25in</Top>
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox11</Value>
</Textbox>
<Textbox Name="textbox1">
<Top>0.625in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox10</Value>
</Textbox>
<Textbox Name="textbox3">
<rdBig SmileefaultName>textbox3</rdBig SmileefaultName>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.5in</Height>
<Value>Sub Report2 - TextBox9</Value>
</Textbox>
</ReportItems>
</Rectangle>
</ReportItems>
<Height>4.875in</Height>
</Body>
<rd:ReportID>27945455-ce7b-4449-919c-771216f4ff66</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<Code />
<Width>6in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>0.25in</TopMargin>
</Report>




Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot

After speding hours and hours about this issue, here is what I found in the MSDN.

http://support.microsoft.com/kb/938943


SYMPTOMS
In Microsoft SQL Server 2005 Reporting Services or in Microsoft SQL Server 2000 Reporting Services, blank space appears in a file that you export. This problem occurs if the following conditions are true:
? You export the report to a physical page format file, such as a PDF document or an image file.
? The report contains a subreport.
Additionally, blank space appears in the preview report when you preview the report before you print it.

Back to the top

CAUSE

This behavior occurs because the Subreport control has an implicit KeepTogether property. By design, the KeepTogether property tries to keep content of a subreport on one page. Because of this behavior, the report engine creates blank space on the main report if the subreport does not fit on the same page as the main report. Then, the report engine creates the subreport on a new page.

Back to the top

WORKAROUND

To work around this behavior, follow these steps:
1. Make sure that your report does not use the Subreport control.
2. Move the data in the subreport into the main report.





Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot

Is there any hot fix or some other work around (other than suggesting that don't use the subreport control).




Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

?®€?§Q?

I've never used the subreport control. I just use navigation to simulate a "drillthrough" report. Maybe this would be a better solution for you.






Re: Continuous Priniting - PDF (NEVER EVER USE SUB REPORTS IF YOU WANT TO PRINT)

Surkot

There is no drill through reports in our scenario. We have a data entry app (input is 30 pages of word document). Once the date entry is done we want to produce a nice large report (almost similar to the paper based one)