Exporting reports to PDF

Does anybody know how to export reports to PDF so that it fit to page?

Thanks,

Addin

hii

do you want the visual studio report what ever you developed to in sql server 2005 to be exported into pdf format ?

then just see the preview of your report. then in that same page one botton is there just before to the fontsize called the export bottom. just see the drop down list to what you wanted to export your report ,you can choose there. you can see there that you can export your report to tiff format,web archive format,pdf format and excel format also.

hope you have asked this

then it will work fine for you

thanks and regards

mahasweta

|||

hii

you can do it on the same page of the rivew of the ssrs in visual studio.there is one botton, just before the font size ,caled export .just check there .you can export to any format you want.those are tiff format,webarchiev format,pdf and excel format

thanks and regards

mahasweta

|||Hi,
I am not clear about your question?
1)whether you want the data which is running in to the second page has to be fit in to a single page.
2)Do you have blank in second page without any data and you want to reduce no of pages to 1.
If you make this point clear.,then i can help you.|||Hi,

Let's say, i have this Transfer Notice report which has 10 columns.

When i export this report to PDF, i cant see all the 10 columns on page 1. It was split into 2 page.

Page 1 contains 1st - 7th columns, and..
Page 2 contains 8th - 10th columns.

I wanted to see the whole table in one page only. Is there any option so that i could "fit to page" the report?

Thanks for the answers!
|||

i think i have the exact same problem i think.

lets say i make a reporting thats A3 size, when i export to PDF the stupid thing renders it as A4 and mashes it over to another page.

|||Hi,
I got your problem .First check which layout you are using.whether its Landscape or Portrait.
Then your Components (such as List,matrix or Table) + margins(Left,Top,Right,Bottom) should be equal to or less than Page width and height.If the components extends the desired Page width and height then the data will be shifted to next page.
In your case ,Please check your page width.
Hope it was useful to you.

Cheers,
Shri|||Hi,

on the preview, I could set the layout to landscape. But when I export it to PDF, the result's still the same.

I've already check the margins, it's all okay.

Is there anyway to set the layout to landscape as default?

Thanks!
|||

I HAVE THE ANSWER!!!

example, my report needs to be A2 size.

go report>report properties>layout

set your page width and margins to the size you need (mine is 42cm,59.4cm)

this is the only thing that forces pdf rendering to go beyond the standard A4 size.

|||Great!

Thanks!

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting Reports creates a blank window

I have created a few reports and linked them to a URL on a web page. (sample link is : http://servername/ReportServer/Pages/ReportViewer.aspx?%2fMy_Reports%2fBacklog+Report&rs:Command=Render )

When the user clicks on the link above it renders correctly but when the user tries to export the report to any format on the list, it launches another window with the following URL : http://servername/ReportServer/Reserved.ReportViewerWebControl.axd?ExecutionID=czq4c355dmsxdy55dif1nm55&ControlID=ad74d68e-2a9c-430f-8655-dd0e6c46f831&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Backlog+Report&ContentDisposition=OnlyHtmlInline&Format=EXCEL

which then prompts the user to Open or Save the report.

How do I stop this window from opening ? or how can I make it close automatically ?

Please advise.

I know if I can change the ContentDisposition somehow to AlwaysInline then this extra window will not show during the export but it keeps defaulting to OnlyHTMLInline for ContentDisposition.

Thanks in advance.

AL

Change ContentDispostion = AlwaysInline.|||

I had the same issue, which results from an IE hotfix that is applied to all the workstations at my work site. To get around this issue, I created a WEB project in Visual Studio 2005 and added in the ReportViewer web control. There is where you can overwrite the default setting for ExportContentDisposition. I changed to "AlwaysInline" to get around the problem.

Exporting report to excel [How to set worksheet name]

I am inserting page break after a table to put different data on different
sheet.How can i name the resultant work sheet {like table1 should be
DATA,table2 should be MYSummary}unfortunately, it is not possible. to rename your sheets.
Amarnath, MCTS
"Kamii47" wrote:
> I am inserting page break after a table to put different data on different
> sheet.How can i name the resultant work sheet {like table1 should be
> DATA,table2 should be MYSummary}

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting PDF - Adding empty page

Hi,

I created a report using dynamic display( I hide the column using the expression in Property->Visibility).By using expression the column which is having null is hided.When I try to export the report to PDF,the empty pages are displaying along with data.Ie.,The report contyains only 5 pages but in PDF it is displaying 10 pages(5pages data with 5 empty pages).

Any Suggestions appreciated!

Thanks

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

|||

Chris Baldwin - MSFT wrote:

Please verify that the definition width of your table (regardless of any hidden columns) is less than the width of the body.

Also, be sure that:

Body.Width < Report.PageWidth - Report.LeftMargin - Report.RightMargin

-Chris

I am trying to accomplish the same thing and my problem is the Body width as mentioned by Chris.. it is too wide since my available set of columns is fairly large. Are there any known tricks to work around this limitation, using matrices, or whatever technique?

- Ron

Exporting Groups to Excel

I have a group set up woth page breaks at the end. When I export it to Excel
it generates a separate sheet (tab) for each page. Is there a way to get it
to export into one sheet, with page breaks in the correct locations?
--
-MTThere appears to be no way around this if <PageBreakAtEnd> is true when
exporting to Excel. When a report is exported to Excel, each page in the
report becomes a worksheet (and you can't name the worksheets either).
--
Adrian M.
MCP
"MT" <MT@.discussions.microsoft.com> wrote in message
news:7552EDA9-F6F9-4008-B902-8A8FA5FFC1C6@.microsoft.com...
>I have a group set up woth page breaks at the end. When I export it to
>Excel
> it generates a separate sheet (tab) for each page. Is there a way to get
> it
> to export into one sheet, with page breaks in the correct locations?
> --
> -MTsql

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/TIFF

When I try to export to PDF or TIFF the report seems to give me 1 page then
2 pages only containing the page header and page footer then the next page
followed by 2 pages with only header and footer and so forth.
We have just installed SP1 which did not fix this problem.
Another issue not fixed by SP1 is that we use a specific font which is
installed on both server and client that shows as a different font on the
PDF export however is fine on every other export.
Any ideas?
Regards
JonasHmm Sorry please disregard the header/footer page bit. However the font
issue is still an issue.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...
> When I try to export to PDF or TIFF the report seems to give me 1 page
then
> 2 pages only containing the page header and page footer then the next page
> followed by 2 pages with only header and footer and so forth.
> We have just installed SP1 which did not fix this problem.
> Another issue not fixed by SP1 is that we use a specific font which is
> installed on both server and client that shows as a different font on the
> PDF export however is fine on every other export.
> Any ideas?
> Regards
> Jonas
>|||Can you give a specific example of the font issue? Is it a True Type font?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:u8KyQNLXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Hmm Sorry please disregard the header/footer page bit. However the font
> issue is still an issue.
> Regards
> Jonas
> "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...
>> When I try to export to PDF or TIFF the report seems to give me 1 page
> then
>> 2 pages only containing the page header and page footer then the next
>> page
>> followed by 2 pages with only header and footer and so forth.
>> We have just installed SP1 which did not fix this problem.
>> Another issue not fixed by SP1 is that we use a specific font which is
>> installed on both server and client that shows as a different font on the
>> PDF export however is fine on every other export.
>> Any ideas?
>> Regards
>> Jonas
>>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_00A2_01C45D31.67ADF190
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Seems like the file was blocked but:
A is what it should look like but it looks like A in the PDF Export =where as it look fine before the export. Again we have installed SP1 and =the font is available on both server & client.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message =news:ueda9cNXEHA.4032@.TK2MSFTNGP11.phx.gbl...
Yes it is a true type font. My conmpay have their logo as a font but =once
exported to PDF it shows as a normal font. Where as it comes up ok in =eg
Excel.
From the Document Properties in Acrobat Reader it says
Type: True Type
Encoding: Ansi
Actual Font: Adibe Sans MM
In the attached file is how it looks once exported to pdf and how is =looks
before export.
Regards
Jonas
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in =message
news:uQVTQyMXEHA.1684@.tk2msftngp13.phx.gbl...
> Can you give a specific example of the font issue? Is it a True Type =font?
>
> -- > Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> news:u8KyQNLXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > Hmm Sorry please disregard the header/footer page bit. However the =font
> > issue is still an issue.
> >
> > Regards
> > Jonas
> > "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> > news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...
> >> When I try to export to PDF or TIFF the report seems to give me 1 =page
> > then
> >> 2 pages only containing the page header and page footer then the =next
> >> page
> >> followed by 2 pages with only header and footer and so forth.
> >> We have just installed SP1 which did not fix this problem.
> >>
> >> Another issue not fixed by SP1 is that we use a specific font =which is
> >> installed on both server and client that shows as a different =font on
the
> >> PDF export however is fine on every other export.
> >>
> >> Any ideas?
> >>
> >> Regards
> >> Jonas
> >>
> >>
> >
> >
>
>
--=_NextPart_000_00A2_01C45D31.67ADF190
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Seems like the file was blocked =but:
A is =what it should look like but it looks like A in the PDF Export =where as it look fine before the export. Again we have installed SP1 and the font is =available on both server & client.
Regards
Jonas
"Jonas Larsen" =wrote in message news:ueda9cNXEHA.4032=@.TK2MSFTNGP11.phx.gbl...Yes it is a true type font. My conmpay have their logo as a font but onceexported to PDF it shows as a normal font. Where as it comes =up ok in egExcel.From the Document Properties in Acrobat Reader it says Type: True Type =Encoding: Ansi Actual Font: Adibe Sans MMIn the =attached file is how it looks once exported to pdf and how is looksbefore export.RegardsJonas"Brian Welcker [MSFT]" wrote in messagenews:uQVTQyMXEHA.1684@.tk2msftngp13.phx.gbl...> Can =you give a specific example of the font issue? Is it a True Type =font?>> -- > Brian Welcker> Group Program Manager> SQL =Server Reporting Services>> This posting is provided "AS IS" =with no warranties, and confers norights.>> "Jonas Larsen" wrote in message> news:u8KyQNLXEHA.2816@.TK2MSFTNGP11.phx.gbl...> > Hmm Sorry =please disregard the header/footer page bit. However the font> > =issue is still an issue.> >> > Regards> > =Jonas> > "Jonas Larsen" wrote in =message> > news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...> >> =When I try to export to PDF or TIFF the report seems to give me 1 page> => then> >> 2 pages only containing the page header and page =footer then the next> >> page> >> followed by 2 =pages with only header and footer and so forth.> >> We have just =installed SP1 which did not fix this problem.> >>> >> =Another issue not fixed by SP1 is that we use a specific font which is> = >> installed on both server and client that shows as a different =font onthe> >> PDF export however is fine on every other export.> >>> >> Any ideas?> =>>> >> Regards> >> Jonas> >>> >>> >> >>>

---

--=_NextPart_000_00A2_01C45D31.67ADF190--|||This is a multi-part message in MIME format.
--=_NextPart_000_0297_01C45DAF.830CCA50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can you send me the font and the report directly? My address is =bwelcker@.microsoft.com. The only workaround I can think of for now is to =use an image.
-- Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no =rights.
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message =news:OWSTV3NXEHA.2716@.tk2msftngp13.phx.gbl...
Seems like the file was blocked but:
A is what it should look like but it looks like A in the PDF Export =where as it look fine before the export. Again we have installed SP1 and =the font is available on both server & client.
Regards
Jonas
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message =news:ueda9cNXEHA.4032@.TK2MSFTNGP11.phx.gbl...
Yes it is a true type font. My conmpay have their logo as a font but =once
exported to PDF it shows as a normal font. Where as it comes up ok =in eg
Excel.
From the Document Properties in Acrobat Reader it says
Type: True Type
Encoding: Ansi
Actual Font: Adibe Sans MM
In the attached file is how it looks once exported to pdf and how is =looks
before export.
Regards
Jonas
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in =message
news:uQVTQyMXEHA.1684@.tk2msftngp13.phx.gbl...
> Can you give a specific example of the font issue? Is it a True =Type font?
>
> -- > Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers =no
rights.
>
> "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> news:u8KyQNLXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > Hmm Sorry please disregard the header/footer page bit. However =the font
> > issue is still an issue.
> >
> > Regards
> > Jonas
> > "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> > news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...
> >> When I try to export to PDF or TIFF the report seems to give me =1 page
> > then
> >> 2 pages only containing the page header and page footer then =the next
> >> page
> >> followed by 2 pages with only header and footer and so forth.
> >> We have just installed SP1 which did not fix this problem.
> >>
> >> Another issue not fixed by SP1 is that we use a specific font =which is
> >> installed on both server and client that shows as a different =font on
the
> >> PDF export however is fine on every other export.
> >>
> >> Any ideas?
> >>
> >> Regards
> >> Jonas
> >>
> >>
> >
> >
>
>
--=_NextPart_000_0297_01C45DAF.830CCA50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Can you send me the font and the report =directly? My address is bwelcker@.microsoft.com. T=he only workaround I can think of for now is to use an image.
-- Brian WelckerGroup Program ManagerSQL Server =Reporting Services
This posting is provided "AS IS" with no warranties, and confers no =rights.
"Jonas Larsen" =wrote in message news:OWSTV3NXEHA.2716=@.tk2msftngp13.phx.gbl...
Seems like the file was blocked =but:

A is what it should look like but it looks like A in the PDF Export =where as it look fine before the export. Again we have installed SP1 and the =font is available on both server & client.

Regards
Jonas
"Jonas Larsen" =wrote in message news:ueda9cNXEHA.4032=@.TK2MSFTNGP11.phx.gbl...Yes it is a true type font. My conmpay have their logo as a font but onceexported to PDF it shows as a normal font. Where as it comes =up ok in egExcel.From the Document Properties in Acrobat =Reader it says Type: True Type =Encoding: Ansi Actual Font: Adibe Sans MMIn the =attached file is how it looks once exported to pdf and how is looksbefore = export.RegardsJonas"Brian Welcker [MSFT]" wrote in messagenews:uQVTQyMXEHA.1684@.tk2msftngp13.phx.gbl...> Can =you give a specific example of the font issue? Is it a True Type font?>> -- > Brian Welcker> Group =Program Manager> SQL Server Reporting Services>> This =posting is provided "AS IS" with no warranties, and confers norights.>> "Jonas Larsen" = wrote in message> news:u8KyQNLXEHA.2816@.TK2MSFTNGP11.phx.gbl...> > Hmm Sorry =please disregard the header/footer page bit. However the font> > =issue is still an issue.> >> > Regards> > =Jonas> > "Jonas Larsen" wrote in =message> > news:e67RXWKXEHA.1128@.TK2MSFTNGP10.phx.gbl...> >> =When I try to export to PDF or TIFF the report seems to give me 1 =page> > then> >> 2 pages only containing the page header and =page footer then the next> >> page> >> followed =by 2 pages with only header and footer and so forth.> >> We =have just installed SP1 which did not fix this problem.> =>>> >> Another issue not fixed by SP1 is that we use a specific =font which is> >> installed on both server and client that shows =as a different font onthe> >> PDF export however is fine =on every other export.> >>> >> Any =ideas?> >>> >> Regards> >> Jonas> >>> >>> >> =>>>=

---

--=_NextPart_000_0297_01C45DAF.830CCA50--

Export to PDF Page Settings

Hi all
I have made a report that is massively to wide to fix into an A4 PDF
when it is exported from the report server. Is there a way I can make
the layout of the PDF landscape and/or tell the report server to
shrink everything to fit the page?
An example of what to do would really help if possible
Thanks for any help you can give me on this
RichardHi, I had this same problem. This is what I did to fix it..go to Report -
Report Properties - and play with the page width and page height. I think I
changed the width to 12 and height to 8.5, it displayed pdf as landscape.
Try 'Page Width' functionality to view the report, might help.
"Frog" wrote:
> Hi all
> I have made a report that is massively to wide to fix into an A4 PDF
> when it is exported from the report server. Is there a way I can make
> the layout of the PDF landscape and/or tell the report server to
> shrink everything to fit the page?
> An example of what to do would really help if possible
> Thanks for any help you can give me on this
> Richard
>

Export to PDF only showing 1 Page

Hello,
I have a simple report (rdl available but the ms browser wont let me upload
it) that runs and displays fine on screen; when a user does an export to pdf
they only get the first page. On screen we are seeing 18 pages in total in
IE.
When we export to PDF we only get the first page; exporting to excel is
showing all the information correctly...
The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
and either windows xp / ie6 / ie7 and the same is happening for all users.
We are accessing the reports from inside an iframe generally; calling the
report with the required parameters. Though when we try it using the URL the
same export happens.
There are about 40 reports on the server and only this one is affected.
Thanks
ChrisIt might be that some of the report elements are sitting on top of each
other.
Try opening the report in your designer, and move all the elements so that
you make sure none are covering the others. Then upload and see if this
solves it.
Kaisa M. Lindahl Lervik
"Chris Hoare" <choare@.nospam.nospam> wrote in message
news:0004CD40-F271-4AC9-9875-3276DC0B5558@.microsoft.com...
> Hello,
> I have a simple report (rdl available but the ms browser wont let me
> upload
> it) that runs and displays fine on screen; when a user does an export to
> pdf
> they only get the first page. On screen we are seeing 18 pages in total in
> IE.
> When we export to PDF we only get the first page; exporting to excel is
> showing all the information correctly...
> The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
> and either windows xp / ie6 / ie7 and the same is happening for all users.
> We are accessing the reports from inside an iframe generally; calling the
> report with the required parameters. Though when we try it using the URL
> the
> same export happens.
> There are about 40 reports on the server and only this one is affected.
> Thanks
> Chris
>
>|||No there are no hidden overlapping The only expressions in the report handle
some color formatting on the numbers on the report to highlight exceptions.
We managed to get it to export on a pc running XP SP2 / Office 2003 last
night; but we havent had any luck with other reports.
Also tried deleting it out from reporting services manager, changing the
report history to store 1 copy of the report.|||Hi choare,
Thank you for the post.
Would you pleae send the report file to me? You may send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com (Please remove the ONLINE when you send the
mail), you may send the file to me directly and I will keep secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Export to PDF makes empty pages

When I export a report to PDF I get every second page (even pages) a blank
one
What's wrong ?The page border exceed the printable frame, try to small down your viewable
area in the report or to decrease your borders . This might help,
HTH, Jens Süßmeyer
--
http://www.sqlserver2005.de
--
"spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
news:%235h9lvAQFHA.580@.TK2MSFTNGP15.phx.gbl...
> When I export a report to PDF I get every second page (even pages) a blank
> one
> What's wrong ?
>|||Doesn't work.
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> a scris
în mesajul de ºtiri:OcH7myAQFHA.2588@.TK2MSFTNGP10.phx.gbl...
> The page border exceed the printable frame, try to small down your
> viewable
> area in the report or to decrease your borders . This might help,
> HTH, Jens Süßmeyer
> --
> http://www.sqlserver2005.de
> --
>
> "spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
> news:%235h9lvAQFHA.580@.TK2MSFTNGP15.phx.gbl...
>> When I export a report to PDF I get every second page (even pages) a
>> blank one
>> What's wrong ?
>|||I am quite sure that one report element overlaps the borders,
I you can´t get any further try to eliminates element by element to see
where
this could come from (Often it is something like a line which is very hard
to see
in design)
Jens.
"spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
news:Oc3qK%23AQFHA.2136@.TK2MSFTNGP14.phx.gbl...
> Doesn't work.
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> a scris
> în mesajul de ºtiri:OcH7myAQFHA.2588@.TK2MSFTNGP10.phx.gbl...
>> The page border exceed the printable frame, try to small down your
>> viewable
>> area in the report or to decrease your borders . This might help,
>> HTH, Jens Süßmeyer
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
>> news:%235h9lvAQFHA.580@.TK2MSFTNGP15.phx.gbl...
>> When I export a report to PDF I get every second page (even pages) a
>> blank one
>> What's wrong ?
>>
>|||Solved. But I don't know how. Probably the Body was too big ? It's a A4
landscape report but the body initial was smaller than the page. Now I've
done it more smaller and it's working.
Thank's
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> a scris
în mesajul de ºtiri:e7DXMCBQFHA.904@.tk2msftngp13.phx.gbl...
>I am quite sure that one report element overlaps the borders,
> I you can´t get any further try to eliminates element by element to see
> where
> this could come from (Often it is something like a line which is very hard
> to see
> in design)
> Jens.
> "spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
> news:Oc3qK%23AQFHA.2136@.TK2MSFTNGP14.phx.gbl...
>> Doesn't work.
>> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> a
>> scris în mesajul de ºtiri:OcH7myAQFHA.2588@.TK2MSFTNGP10.phx.gbl...
>> The page border exceed the printable frame, try to small down your
>> viewable
>> area in the report or to decrease your borders . This might help,
>> HTH, Jens Süßmeyer
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "spp" <spp@.nospam.nospam> schrieb im Newsbeitrag
>> news:%235h9lvAQFHA.580@.TK2MSFTNGP15.phx.gbl...
>> When I export a report to PDF I get every second page (even pages) a
>> blank one
>> What's wrong ?
>>
>>
>

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 everyone,
I learnt from one of the treads here that inorder to export
the report to pdf in a single page we need to set the width and height to be
11in and 8.5in.But when i print the report after exporting to pdf,it prints
in the landscape mode.how Can it be made to print in the portrait mode'
Thanks in Advance...Hi,
Another problem for me is when i export to pdf it prints one extra
blank page.
Why is it so'
Eagerly waiting for ur responses,
Chandra.
"Chandra" wrote:
> hi everyone,
> I learnt from one of the treads here that inorder to export
> the report to pdf in a single page we need to set the width and height to be
> 11in and 8.5in.But when i print the report after exporting to pdf,it prints
> in the landscape mode.how Can it be made to print in the portrait mode'
> Thanks in Advance...|||Hi Chandra,
According to your own settings, width and height are 11in and 8.5in, so this
IS landscape...
You should switch the sizes.
As far as I know, there is no setting of portrait/landscape other than
choosing the height and width accordingly.
HTH,
Andrei.
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:B671220F-F220-43D0-B263-965106398D9E@.microsoft.com...
> hi everyone,
> I learnt from one of the treads here that inorder to
export
> the report to pdf in a single page we need to set the width and height to
be
> 11in and 8.5in.But when i print the report after exporting to pdf,it
prints
> in the landscape mode.how Can it be made to print in the portrait mode'
> Thanks in Advance...|||Hi Chandra,
You should try making the width smaller.
Ex. if Report width is 11, try 10.4 or if 8.5 then try 8.
The next blank page is because the report tries to print outside the
printable area on the current page.
HTH,
Andrei.
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:952614A8-A9FF-47B8-A998-BDA956FE18E4@.microsoft.com...
> Hi,
> Another problem for me is when i export to pdf it prints one extra
> blank page.
> Why is it so'
> Eagerly waiting for ur responses,
> Chandra.
> "Chandra" wrote:
> > hi everyone,
> > I learnt from one of the treads here that inorder to
export
> > the report to pdf in a single page we need to set the width and height
to be
> > 11in and 8.5in.But when i print the report after exporting to pdf,it
prints
> > in the landscape mode.how Can it be made to print in the portrait mode'
> >
> > Thanks in Advance...|||When I export to pdf, there is always an extra page at the end. In viewing
in Visual Studio, if there are 11 pages, there will be 12 pages in pdf. Why?
Blank pages after each page points to width and margin settings, but extra
blank page at end is weird?
Any ideas why this is happening?
"andrei" wrote:
> Hi Chandra,
> According to your own settings, width and height are 11in and 8.5in, so this
> IS landscape...
> You should switch the sizes.
> As far as I know, there is no setting of portrait/landscape other than
> choosing the height and width accordingly.
> HTH,
> Andrei.
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:B671220F-F220-43D0-B263-965106398D9E@.microsoft.com...
> > hi everyone,
> > I learnt from one of the treads here that inorder to
> export
> > the report to pdf in a single page we need to set the width and height to
> be
> > 11in and 8.5in.But when i print the report after exporting to pdf,it
> prints
> > in the landscape mode.how Can it be made to print in the portrait mode'
> >
> > Thanks in Advance...
>
>|||Hi guys,
I have found that body size must be less or equal to the page size. If
your page's width is 11in than body's width should be <= 11in * 2.54
(27.94cm). It works in my case, I do not have an extra page any more.

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 PDF

I have a wide report and i want to export it to PDF in lanscape mode. How can i do that? Setting page layout in ReportViewer control has no effect on generated PDF document - it is always in portrait mode.

Check out Brian Welcker's blog entry on the topic:

http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx

Thanks, Donovan.