Drill down report hide/ show with SSRS 2008
-
Thursday, February 21, 2013 10:26 AM
Created a SSRS 2008 report with a drill down report. in the report i have 6 level (as of now it may increase) and my need is first two levels should be show and remaining levels in hide.
example:
- test1
-Test 2
+ test 3
+ test 3
- Test 2
+ test 3
here my problem is in the third level i'm not getting the + symbol instead i'm getting - symbol. please help me out to get resolve this issue.
All Replies
-
Thursday, February 21, 2013 11:28 AMIf you're just looking to switch the - to a + on this third level, try changing the initial toggle state: click on the cell where you want to make this change, then look at the properties. In the list of properties you should see a property called InitialToggleState or something to that effect. Change that and then run your report to see if it has the desired effect.
-
Thursday, February 21, 2013 12:09 PM
i have tried that option with this condition "=IIf(Fields!LevelToOpen.Value=1,true,false)". here LevelToOpen value is 1 for first three level and for remaining levels passing 0. so that i'm getting the below look and feel. but the third level (test 3) should have + symbol.
- test1
-Test 2
- test 3
- test 3
- Test 2
- test 3
-
Wednesday, February 27, 2013 10:39 AMModerator
Hello,
Currently, it is hard to reproduce the issue without understand the data structure. Could you please post both the report and the dataset with sample data to us by the following E-mail address? It is benefit for us to do further analysis.
E-mail: sqltnsp@microsoft.comRegards,
Fanny LiuFanny Liu
TechNet Community Support
.png)
