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 - 2010-08-04 : 23:05:53
|
| I have 10 main fields and they're rolled up and summed.I have another 10 to 15 columns that I do not want to show until the user clicks on the drill down [User ID]I have 2 Row Groups Table1_User_ID = which is the rolled up data and the user has the + sign to drill intoTable1_Details_Group which is my details.I tried to use the following=IIF("table1_User_ID"="None" ,False,True)It does hide the fields when the report is initially ran. But when the drill down is selected they do not appear. Any suggestions ? |
|
|
|
|
|
Hiding Columns until Drill Down Selected