Page Break at End throws unwanted additional blank page in PDF

Hi,
Originally posted as "Extra Page Break thrown in Export to PDF" - however I
thought this might be misinterpreted as a page size issue.
We have a report which has a group. The "Page Break at End" option is
checked for the group. The report renders correctly in the report manager
with totals immediately under the last group.
Unfortunately, when exporting to PDF, an additional blank page is added.
Can this be avoided?
Note, the report has three tables which are directly on top of each other -
the tables are all sitting within a rectangle.
many thanks
MattJust a thought - Could I edit the RDL file directly and put a condition in
the PageBreak at End element - is this an possibility?
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||In answer to editing the RDL - unfortunately, no.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||Actually, the additional page only seems to occur when the table has rows
after the last group - in my case, it's a grand total field
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||I believe there are some issues with page breaks while exporting to PDFs..
Hopefully some of these kinds of things will be fixed as time goes forward,
I have yet to be able to eliminate all of the extra pages as well...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
> I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
> other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||I have found a work around - although it's a bit clunky.
The issue seems to be where you have something appearing after the last
group. If there is nothing after the last group, the report exports to PDF
correctly. But because I want grand totals I have not been able to simply
put a summation in the table footer.
Firstly, I am using a stored procedure as my report data source.
I added two additional fields to my stored procedure result set a) a grand
total field and b) a last group flag.
I then put the grand total field into a footer row of the outermost group
and set the hidden property to an expression including the Last Group flag
which evaluates to false when at the last group.
This is not a particularly complex thing to work around - but was quite
painful as I resist having to use unintuitive solutions such as this because
they make maintenance more difficult :)
Note: I would have used pagenumbering to determine the last page but
unfortunately, the Global values for Pagenumber and TotalPages are not
accessible within the body of the report.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OLxJc%23NGFHA.2932@.TK2MSFTNGP15.phx.gbl...
> I believe there are some issues with page breaks while exporting to PDFs..
> Hopefully some of these kinds of things will be fixed as time goes
forward,
> I have yet to be able to eliminate all of the extra pages as well...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> > I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> > other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>sql