Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts

Friday, March 9, 2012

Export to PDF has extra page?

Hello,

When I export to PDF or Tiff, I am getting an extra blank page at the bottom of the document. Any ideas what might be causing this blank page during my export?

BTW...SSRS 2005 SP1

TIA!!!!

It could be extra white space to the right of a matrix or table rendered as a blank, last page.|||This is almost certainly that the width of the formatted page exceeds the margin and trails onto the next page. I've had the same experience.|||

Yes, I believe I see the problem now...

By default, a new report will display a designer pane with a 6.5x2 size. You can't fit a heck of a lot on this pane, so you immediately increase the size by dragging the pane out beyone the 6.5 range. Well with the default 1 inch margins on each side, when this goes to render in PDF, you see an extra "blank" page. In order to get around it you can keep the designer with all the default settings, or you can change the margins and adjust the designer width/height to fit your needs.

Hope this helps others!!!

|||

Hi,

Im having problem with SSRS export to pdf.. the file size is too big, about 10mb. im using windows 2003 64bit rs and sql 2005.

Please advice.

Export to PDF has extra page?

Hello,

When I export to PDF or Tiff, I am getting an extra blank page at the bottom of the document. Any ideas what might be causing this blank page during my export?

BTW...SSRS 2005 SP1

TIA!!!!

It could be extra white space to the right of a matrix or table rendered as a blank, last page.|||This is almost certainly that the width of the formatted page exceeds the margin and trails onto the next page. I've had the same experience.|||

Yes, I believe I see the problem now...

By default, a new report will display a designer pane with a 6.5x2 size. You can't fit a heck of a lot on this pane, so you immediately increase the size by dragging the pane out beyone the 6.5 range. Well with the default 1 inch margins on each side, when this goes to render in PDF, you see an extra "blank" page. In order to get around it you can keep the designer with all the default settings, or you can change the margins and adjust the designer width/height to fit your needs.

Hope this helps others!!!

|||

Hi,

Im having problem with SSRS export to pdf.. the file size is too big, about 10mb. im using windows 2003 64bit rs and sql 2005.

Please advice.

Export to PDF has extra blank page??

Hello,
When I export to PDF or Tiff, I am getting an extra blank page at the bottom
of the document. Any ideas what might be causing this blank page during my
export?
BTW...SSRS 2005 SP1
TIA!!!!Make sure you have the size of page set properly.
If the report header + body height + footer > report height
OR left margin + body width + right margin > report body width ...u tend to
get blank pages.
Sunny
"brianpmccullough" wrote:
> Hello,
> When I export to PDF or Tiff, I am getting an extra blank page at the bottom
> of the document. Any ideas what might be causing this blank page during my
> export?
> BTW...SSRS 2005 SP1
> TIA!!!!
>|||Hi Sunny/Brian,
I also face the same issue , of extra blank page on PDF export. I
initially increased
the pagewidth to show all columns on single page but i'm getting a blank
page which user doesn't want to see it. I applied the formula you had
mentioned
ReportHeader 1.7698cm
BodyHeight 12.22 Cm
ReportFooter .635 cm
Report PageHeight 16cm
Left Margin 0.25 cm
body Width 18.925 in
right Margin 0.25cm
Report PageWidth 20.3 in
reportheader + body height + footer < report Pageheight
and left margin + body width + right margin < report Pagewidth
Still i'm getting a extra blank page
As you can see
Thanks!
Rags
"Sunny" wrote:
> Make sure you have the size of page set properly.
> If the report header + body height + footer > report height
> OR left margin + body width + right margin > report body width ...u tend to
> get blank pages.
> Sunny
> "brianpmccullough" wrote:
> > Hello,
> >
> > When I export to PDF or Tiff, I am getting an extra blank page at the bottom
> > of the document. Any ideas what might be causing this blank page during my
> > export?
> >
> > BTW...SSRS 2005 SP1
> >
> > TIA!!!!
> >|||I have this happen when I have a textbox or other object that is right up to
the right edge of the body.
=-Chris
"RAGHAVAN JAYARAMAN" <RAGHAVANJAYARAMAN@.discussions.microsoft.com> wrote in
message news:F26151BD-6B79-4508-94B2-B18E144AD553@.microsoft.com...
> Hi Sunny/Brian,
> I also face the same issue , of extra blank page on PDF export. I
> initially increased
> the pagewidth to show all columns on single page but i'm getting a blank
> page which user doesn't want to see it. I applied the formula you had
> mentioned
> ReportHeader 1.7698cm
> BodyHeight 12.22 Cm
> ReportFooter .635 cm
> Report PageHeight 16cm
> Left Margin 0.25 cm
> body Width 18.925 in
> right Margin 0.25cm
> Report PageWidth 20.3 in
> reportheader + body height + footer < report Pageheight
> and left margin + body width + right margin < report Pagewidth
> Still i'm getting a extra blank page
> As you can see
> Thanks!
> Rags
>
>
>
>
> "Sunny" wrote:
>> Make sure you have the size of page set properly.
>> If the report header + body height + footer > report height
>> OR left margin + body width + right margin > report body width ...u tend
>> to
>> get blank pages.
>> Sunny
>> "brianpmccullough" wrote:
>> > Hello,
>> >
>> > When I export to PDF or Tiff, I am getting an extra blank page at the
>> > bottom
>> > of the document. Any ideas what might be causing this blank page
>> > during my
>> > export?
>> >
>> > BTW...SSRS 2005 SP1
>> >
>> > TIA!!!!
>> >