exporting multiple rows

I'm trying to set up a row that has 5 rows below it and when you click on the + it'll expand to show the five lines.

They're all set up to toggle based on the one row. It works online, but when I try to export it to anything, it only picks up the first detail row and leaves off the rest. I'm doing this for a bunch of reports, and they're all being emailed using subscriptions.

I've moved the detail rows around but each time it's just the first detail row that is exported.

Any ideas?

thx,

M@.

mattcushing@.gmail.com(noSpam)

Hello,

What formats are you trying to export to? Toggleable visibility is only supported in a few rendering extensions (HTML, Winforms, and in some cases Excel).

When you export to PDF or Image, those renderers honor the toggle state at the time the file is exported. So, if you have all of your toggleable items collapsed and then export to PDF you will only see the collapsed representation.

-Chris

sql

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
>