sql server reporting services: Export to PDF only showing 1 Page -- sql server reporting services

You're in the

sql server reporting services

group:

Export to PDF only showing 1 Page

Chris Hoare
5/22/2006 4:16:02 AM

sql server reporting services: 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

Re: Export to PDF only showing 1 Page

Kaisa M. Lindahl Lervik
5/22/2006 4:44:36 PM

It 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

[quoted text, click to view]

Re: Export to PDF only showing 1 Page

Chris Hoare
5/23/2006 5:52:02 AM

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.

Re: Export to PDF only showing 1 Page

weilu NO[at]SPAM online.microsoft.com
5/24/2006 12:00:00 AM

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.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn