5. ledna 2006 4:05
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?
7. ledna 2006 3:35Moderátor
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.
25. ledna 2006 1:33
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.
13. července 2007 7:56Did 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.
13. srpna 2009 9:44Did anyone find a solution to this?
I have a simple table in my report (RS2005). I have a details row that has its visibility toggled by a cell in the detail row above (2 details rows in total). By default the toggle is collapsed and the details are hidden. But when i export to excel (2003) the talble is fully expanded, with no +/- option, no indentation, such that it is not even clear that one row is the child of another.
Some people have reported having this problem here, and others have said that there's was fine. Any idea what's goimng on??
25. března 2012 12:42
Though it is an old thread, thought of sharing some useful info for people coming here in future...
I recently faced this problem. In my case, the problem was that I configured toggling option only on Row's Visibility property. After configuring the same toggling options on each Group's visibility properties, toggling worked perfectly in exported excel file the same way it worked in the report.