RS prints first page only

Hi,
I have several reports out of which only one report is acting weirdly.
The report displays fine when I open it up but when I try to print it,
it only prints the first page. I tried exporting it to PDF and the same
thing, the PDF has only one page. I tried exporting in all formats and
found that PDF and TIF is not working but the other formats (web
archive, HTML, XML and CSV) are fine. The excel format gives me this
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
I need the PDF format to work. Any ideas why this particular report is
bad? Another note of interest. This report uses a subreport that works
fine in another report. Please help.
Thanks,
SkudderDid you find a solution?
I'm having the same problem when exporting to Excel. All other export
formats work ok. With the Excel, I get:
"Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index"
I found one link that talked about needing SP1 installed. That did not solve
my problem, however, since I already have SP1 installed.
"anandpoolla@.gmail.com" wrote:
> Hi,
> I have several reports out of which only one report is acting weirdly.
> The report displays fine when I open it up but when I try to print it,
> it only prints the first page. I tried exporting it to PDF and the same
> thing, the PDF has only one page. I tried exporting in all formats and
> found that PDF and TIF is not working but the other formats (web
> archive, HTML, XML and CSV) are fine. The excel format gives me this
> 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
> I need the PDF format to work. Any ideas why this particular report is
> bad? Another note of interest. This report uses a subreport that works
> fine in another report. Please help.
> Thanks,
> Skudder
>|||Ok, I found a fix:
Does any of your text boxes reference another field?
The following was the syntax I did have, and then what I changed it to that
fixed the problem.
OLD WAY:
=(ReportItems!textbox2.value / ReportItems!textbox3.value)
NEW WAY THAT FIXED THE EXPORT TO EXCEL:
=ReportItems!textbox2.value / ReportItems!textbox3.value
So as you can see, remove the parentheses.
"anandpoolla@.gmail.com" wrote:
> Hi,
> I have several reports out of which only one report is acting weirdly.
> The report displays fine when I open it up but when I try to print it,
> it only prints the first page. I tried exporting it to PDF and the same
> thing, the PDF has only one page. I tried exporting in all formats and
> found that PDF and TIF is not working but the other formats (web
> archive, HTML, XML and CSV) are fine. The excel format gives me this
> 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
> I need the PDF format to work. Any ideas why this particular report is
> bad? Another note of interest. This report uses a subreport that works
> fine in another report. Please help.
> Thanks,
> Skudder
>