exporting

I have noticed on one of my reports that when I export to a .PDF or .TIF file, I get an extra blank page for each page there is data on. However, in Report Designer when I preview the report, it looks fine. Example, I have a report with 7 pages of data. In RD it show ONLY the 7 pages of data. When I export it though, I get 14 pages with 7 blank pages (header only). I have tried to reduce the width of the text boxes thinking I had something spilling over, but it doesn't change anything.
Any thoughts?

Frankcheck that your body and Report size properties are the same, and the margins preferably set to all 0 just in case you cross over some margins. and that there are no elements in the report which expand bigger than the size of the report when it gets rendered. and ofcourse if you set your tables/matrix/list/rectangle page breaks more than you need like a pagebreak both before and after in the middle of report. most of all make sure the width of your body at design time do not exceed the page size. the length is ok but the width must not go wider and it doesnot matter if there is nothing in the extra space it will still print out an extra page.
to check if your report will export an extra page, look at print preview when you render the report. the normal view may show 2 pages but the print preview will show 4 pages if report is not set up properly.|||

That was it. The report was the same size as the body however the body had .25 set for the margin. By setting the margins to 0 on the body and reducing the report from 8" to 7", it eliminated the extra blank page on the export.
Thanks again!

Exported PDF contains Extra Pages

Hi guys!

When displaying report using a ReportViewer, the single page displayed is just fine. An image at the left side, at table of information at the right. However, when exported to pdf, the image and the table is rendered on separate individual pages.

Is there anyway to modify this behaviour?

Thank in advance!

Have you tried to reduce the width of the report's body?

HTH, Best Regards|||

Hi visa,

Haven't done that yet but I would like to ask, why do you think the report's width thats causing this behaviour? I'm still new to Reporting Services... =)

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!!!!
>> >

Export to PDF

Hi i have a report. In the preview it looks fine but when i export to PDF it prints one extra page after each page. I checked the page height and width...they look fine.
Any ideas why this is happening and what is the solution.
Any help would be appreciated.
ThanksPlease make sure that your report is setup as follows:
Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Let me know is this did not work.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ReportFAQGuy" <ReportFAQGuy@.discussions.microsoft.com> wrote in message
news:63F13042-DFAB-406F-A6AC-01E2F41B5350@.microsoft.com...
> Hi i have a report. In the preview it looks fine but when i export to PDF
it prints one extra page after each page. I checked the page height and
width...they look fine.
> Any ideas why this is happening and what is the solution.
> Any help would be appreciated.
> Thanks
>

Export to Excel yields extra columns

I have a table in a report and the report also includes a page header area.
When I export to Excel, I get a lot of extraneous additional columns in
between my columns of data -why is this and how do I get rid of these?
thanks!
MarthaYou have to make your headings the same width as all of columns below it.
Martha wrote:
>I have a table in a report and the report also includes a page header area.
>When I export to Excel, I get a lot of extraneous additional columns in
>between my columns of data -why is this and how do I get rid of these?
>thanks!
>Martha
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1

Export to Excel

Hi,

When our report exported to Excel, In the Excel file it is giving some extra columns between the data columns.How to avoid those extra columns.This extra columns causes problems when we want to sort one column it is throwing sort can't be applied on merged columns.

How to avoid the Extra columns.

Thanks in advance

Hello Mahima,

You need to make sure that everything in your report lines up, this includes objects in your report header and footer. When objects do not line up, it creates a column so that the excel export looks like the actual report (or as close as it can).

Hope this helps.

Jarret

|||

Hi Jarret,

Lineup means what we need to check, In my report I have one table in which table header is formed by merging two cells.

|||

Try to merge all the cells in the header. If it was a list you had to make sure that all fields (header and data) are vertically aligned i.e. same Y-Axis location.

Shyam

|||

Hi,

In my report header i have the text boxes those are in the following format:

Date: Parameters!Date.value

Name: parameters!Name.Value

and one image

How to merge these to line up to avoid excel extra columns

Thanks

|||

Hello,

Here's what I would do...

Turn 'Snap to grid' and 'Draw grid' options on. Set the position of the first textbox to have the same left position as one of the columns dividers in the table, then increase/decrease the width of the textbox so that the right edge falls on the same Y coordinate as another one of your column dividers. Do the same for your second textbox and your image.

Jarret