SSRS export to excel expanded and collapse

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSRS export to excel expanded and collapse

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-01-20 : 21:02:40

Hi Guys,

I have an SSRS report. when i exported the result to excel

I notice that my Column header has a + sign instead it should be in the row

also when i click the + HTC1173-RTR the records of HTC1177-RTR is the one displayed data. Does anyone know the problem?

Parent group = ITEMID
Child group = Sales ID

sample:

+ ITEMID SALESID

-----------------------------

+ HTC1173-RTR

+ HTC1177-RTR

Should be:

ITEMID SALESID

------------------

+ HTC1173-RTR

+ HTC1177-RTR

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-01-20 : 21:33:54

I got it..closed...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources