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 |
|
ZMike
Posting Yak Master
110 Posts |
 Posted - 2011-06-01 : 16:15:45
|
| I have a report that has a lot of details to it. However until someone drills down to a certain degeree I want entire columns to be hidden until the drill down is selected.Has anyone found an answer to this ?Example... the last row is set to hidethe Display can be toggled by this report has a field selected. for the grouping of the drill down.I want to basically use that same logic but apply it to the column visibility. If I try and use that exact method for the column visibility I get the followingError 1 [rsInvalidToggleItem] The tablix ‘table1’ has ‘Salesman_Department’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-06-03 : 11:55:10
|
| you would be better off posting a screenshot of problem you're facing as we cant make out how you want to hide the columns------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Gururaj
Starting Member
5 Posts |
Posted - 2011-06-30 : 23:48:54
|
| Hi Zmike, I m also having same problem as you mentioned above, if u got a solution for that problem let me know plz My Email-Id : gbhande104@gmail.comThanks and Regards GuruGururaj Bhande |
|
|
|
|
|
|
Hiding Columns until Drill down is selected