sql server reporting services: I do want Collapsed Columns (+/-) to export in excel. -- sql server reporting services

I do want Collapsed Columns (+/-) to export in excel.

Sanjay
10/23/2006 11:10:03 AM

sql server reporting services: Hi,
I have a simple requirement, I do want to show columns in collapsed
mode(with +/-) when it is exported to excel.
i.e I have some groups in report and by default they are in collapsed mode,
so when we click on export to excel, data in excel also shows with +/- which
I don't want.
Any idea how this expected behaviour can be changed for export funtionality ?
--

RE: I do want Collapsed Columns (+/-) to export in excel.

Amarnath
10/24/2006 3:31:01 AM

In a tricky way, you can create a copy of the same report with expanded items.
In your main report create an "Action" and put this report. name the box as
"Save as Excel" ofcourse you need to give in URL access.

Otherwise what you see is what you export.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.