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 excel error

Hi all,
i am not able export to excel, it is showing the below error:
Reporting Services Error
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index
----
Microsoft Reporting Services
anyone faced this porblem earlier, please let me know.
Thanks,
VinodI had the same problem with one of my reports. I found a tip on an MSDN
forum about this. I found that I had numerous formulas encased in outer
parenthesis in my report. Example:
= (ReportItems!<objectname>.Value)
= ((Fields!<objectname>.Value)/(Fields!<objectname>.Value))
Look through your report and remove any outer parenthesis. This should fix
the problem. I hope this helps.
"vinodsh_82@.hotmail.com" wrote:
> Hi all,
> i am not able export to excel, it is showing the below error:
>
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown.
> Index was out of range. Must be non-negative and less than the size of
> the collection. Parameter name: index
> ----
> Microsoft Reporting Services
> anyone faced this porblem earlier, please let me know.
> Thanks,
> Vinod
>