How to show expanded rows in ssrs by default ?

Hello,

I have referred many links similar to this :

http://blogs.interfacett.com/how-to-implement-expand-allcollapse-all-for-drill-down-in-sql-ssrs

But i am unable to implement be default expanded state in my group inside matrix.

Actually i have a matrix and inside that matrix in data field i am using one table now in that table the first column is having + and - signs to expand and collapse all the grouping fields. Now i want to show the data expanded by default for that i have clicked in textbox and set initialtogglestate = true but after report is fetched it shows - sign but rows are collapsed not expanded. 

Please

May 18th, 2015 7:13am

Hi Emad,

According to your description, you have created a tablix, the detail row is toggled by row groups. Also you have created a matrix, embed the tablix in the Data region of the matrix. When you run the report, you want to display the Data region values(tablix values) by default, right?

In your scenario, you could create a tablix and embed it in the matrix. In the tablix, you could set the detail rows can be toggled by each row group. Then specify the value of InitialToggleState as True for the row group. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
May 19th, 2015 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics