Wednesday, March 7, 2012

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

No comments:

Post a Comment