Report not exporting full file

I'm using RS sp1 and have a report that's 50 pages long and has 1000
thumbnail images in it (it serves as a products catalog). When I export as
a PDF or tif, only half the data is exported so in the case of the PDF it
cant open because it says its corrupt, and in the case of a tif, it will
open, but the 2nd half of the pages are missing. The downloaded files are
half the size they should be and when downloading, it say's its complete
after 25 seconds even though its downloaded half the data.
My setup:
1) When I run the report on my local machine and its using sql server and
the image files are stored on the local machine, the report will export
fine.
2) When I run the report from my local machine, but its calling sql server
on a remote server and the image file's paths are to the remote server the
report runs OK, but only half the data is exported.
3) When I run the report from the remote server only half the data is
exported.
Any ideas on what might be happening here?
--
moondaddy@.nospam.comI forgot to mention, if I export it to excel or a web archive I get the
followoing error msg:
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Index was outside the bounds of the array.
----
--
Microsoft Reporting Services
Any idea what its refereing to when it says "Index was outside the bounds of
the array."?
moondaddy@.nospam.com
"moondaddy" <moondaddy@.nospam.com> wrote in message
news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> I'm using RS sp1 and have a report that's 50 pages long and has 1000
> thumbnail images in it (it serves as a products catalog). When I export
as
> a PDF or tif, only half the data is exported so in the case of the PDF it
> cant open because it says its corrupt, and in the case of a tif, it will
> open, but the 2nd half of the pages are missing. The downloaded files are
> half the size they should be and when downloading, it say's its complete
> after 25 seconds even though its downloaded half the data.
> My setup:
> 1) When I run the report on my local machine and its using sql server and
> the image files are stored on the local machine, the report will export
> fine.
> 2) When I run the report from my local machine, but its calling sql
server
> on a remote server and the image file's paths are to the remote server the
> report runs OK, but only half the data is exported.
> 3) When I run the report from the remote server only half the data is
> exported.
> Any ideas on what might be happening here?
> --
> moondaddy@.nospam.com
>|||I had tried to get a report to intentionally abort by throwing an exception in custom code in hopes of being able to not send a subscription if there was no data. Throwing an exception just left me with half a report and no error message just like you described here.
Mike
"moondaddy" wrote:
> I forgot to mention, if I export it to excel or a web archive I get the
> followoing error msg:
> Reporting Services Error
> ----
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Index was outside the bounds of the array.
> ----
> --
> Microsoft Reporting Services
> Any idea what its refereing to when it says "Index was outside the bounds of
> the array."?
>
> --
> moondaddy@.nospam.com
> "moondaddy" <moondaddy@.nospam.com> wrote in message
> news:%232E93MldEHA.2752@.TK2MSFTNGP12.phx.gbl...
> > I'm using RS sp1 and have a report that's 50 pages long and has 1000
> > thumbnail images in it (it serves as a products catalog). When I export
> as
> > a PDF or tif, only half the data is exported so in the case of the PDF it
> > cant open because it says its corrupt, and in the case of a tif, it will
> > open, but the 2nd half of the pages are missing. The downloaded files are
> > half the size they should be and when downloading, it say's its complete
> > after 25 seconds even though its downloaded half the data.
> >
> > My setup:
> > 1) When I run the report on my local machine and its using sql server and
> > the image files are stored on the local machine, the report will export
> > fine.
> > 2) When I run the report from my local machine, but its calling sql
> server
> > on a remote server and the image file's paths are to the remote server the
> > report runs OK, but only half the data is exported.
> > 3) When I run the report from the remote server only half the data is
> > exported.
> >
> > Any ideas on what might be happening here?
> >
> > --
> > moondaddy@.nospam.com
> >
> >
>
>

Report header and footer disappear when exporting

When I export my report to a PDF, everything is fine. However, if I select a group to drill down and then export that drilled down report to a pdf, the reports header and footer disappear. How can I fix this? My report has a few subreports, so that might have something to do with it.
ThanksSee if you find solution here
http://support.businessobjects.com/

report having larger width not printing

Hi,

I have one report with the page size of 17in, 8.5in. Exporting then printing PDF is working fine. But when I am printing directly from report, It is not printing. It is not saying any error. The popup box is coming and showing the message like printing. But it is not printing. I can't change the page size lesser than 17in.

Can you please give some idea for this issue?

Thanks,

Muniappan Kandasamy

You can keep the report body height as anything, it can be as long as you want but keep the interactive height of the report as 11'

A standard portrait style print is of size 8.5" x 11" keep this as the interactive size of your report.

..............................................................................................

Remember to mark as "Answer" on the post that helped you.

http://technoblab.blogspot.com

Report Formatting in Excel 2007

I am currently developing a report for users who insist on exporting to Excel 2007. When I export to Excel on my PC, the report formatting is fine (I am using Excel 2003), however, font sizing as applied in the report is lost when exported to Excel 2007 (i.e. font size 9 in the report is actually 10 in excel 2007). In Excel 2007, the data which runs onto two lines does not show up correctly - the second line is squashed below the first.

Any ideas on how I could resolve this?

Strange, I tried on mine but did not experience this. I tried exporting to Excel 2003 and then opening it in Excel 2007 it worked perfectly fine.

Then I also tried extracting the report from a PC which has Excel 2007 and then exporting the report in that PC, even this worked perfectly fine.