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.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2012-01-27 : 08:38:47
|
| Hi,I have a report which has 5 levels of grouping.On drilling down the lowest level and collapsing the groups till top needs to restore the initial toggle state for everygroup.For example, we have group G1, G2, G3, G4, G5.First when we drill down till G5.Then when collapsing the group at G1 and again drilling down should keep the other subgroups to be collapsed.Please let me know if this could be achievedThanks in advance.- Varalakshmi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-27 : 08:44:12
|
| what have you set as initial visibility state value for the rows g2 to g5?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2012-01-27 : 08:53:17
|
| When the user drills down the report till the lowest granularity and again collapses the entire group at G1 and again tries to drill down from G1, the user should be able to go through G2, G3, G4 and G5 instead of restoring the previous state.- Varalakshmi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-27 : 10:44:28
|
| sorry didnt get answer for question asked------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Toggle visibility in drill down report