Anyone know how to force a new page inbetween Subreports?
I have for example 10 reports which I want to consolidate into a single area of work as one report (i.e. HR reports for month to date).
So Ive created a blank report and added in the subreports needed.
When I go to repreview the reports they all come across as one page.
What im looking for is each being on a separate page or at least starting on a separate page, and at best when I export to excel then the ports appearing as different tabs on the worksheet and not part of one continuous page.
Anyone have an idea on how to do this?
Anyhelp MUCH appreciated.Rectangles support before and after page breaks:
* Place empty rectangles between the subreports and set page break on the
rectangles.
* Place each subreports in a rectangle and place a page break on the
rectangle
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Johnson" <RyanJohnson@.discussions.microsoft.com> wrote in message
news:801596CC-67F5-4EBF-A848-BF40FD30B185@.microsoft.com...
> Ack.. but get the following when viewed in excel.
> 'Subreports within table/matrix cells are ignored.'
> And no matter how many times I change the force new page option "page
break at end", it resets itself back to blank.
>|||Try running the report that follows this posting. It uses 2 textboxes
separated by a rectangle.
The rectangle has a page break set on it. You should get 2 pages.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"chad" <chad@.discussions.microsoft.com> wrote in message
news:D4446D8B-0122-413E-9B6A-B1C89DFA3D6E@.microsoft.com...
> rectangles do have these properties. however, these properties don't seem
to do anything for me. i selected page break before, but it does not insert
the page break.
> "Bruce Johnson [MSFT]" wrote:
> > Rectangles support before and after page breaks:
> > * Place empty rectangles between the subreports and set page break on
the
> > rectangles.
> > * Place each subreports in a rectangle and place a page break on the
> > rectangle
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Ryan Johnson" <RyanJohnson@.discussions.microsoft.com> wrote in message
> > news:801596CC-67F5-4EBF-A848-BF40FD30B185@.microsoft.com...
> > > Ack.. but get the following when viewed in excel.
> > > 'Subreports within table/matrix cells are ignored.'
> > >
> > > And no matter how many times I change the force new page option "page
> > break at end", it resets itself back to blank.
> > >
> > >
> >
> >
> >
RectangleWithPageBreak.rdl
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="CustomerID_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<Top>1.875in</Top>
<rd:DefaultName>CustomerID_1</rd:DefaultName>
<Height>0.25in</Height>
<Width>1in</Width>
<CanGrow>true</CanGrow>
<Value>Second Field</Value>
<Left>0.875in</Left>
</Textbox>
<Rectangle Name="rectangle1">
<ZIndex>1</ZIndex>
<Top>0.625in</Top>
<Height>1in</Height>
<Width>2in</Width>
<Style />
<Left>0.875in</Left>
<PageBreakAtStart>true</PageBreakAtStart>
</Rectangle>
<Textbox Name="CustomerID">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<Top>0.125in</Top>
<rd:DefaultName>CustomerID</rd:DefaultName>
<Height>0.25in</Height>
<Width>1in</Width>
<CanGrow>true</CanGrow>
<Value>First Field</Value>
<Left>0.75in</Left>
</Textbox>
</ReportItems>
<Style />
<Height>2.75in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.62501in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>4f653deb-b9af-49ca-98e1-fe972d395f88</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment