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 |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2009-04-01 : 18:05:21
|
| HiI've been struggling to figure this out for the last two days. I have a matrix that have row group (bars) and column group (rev) and two columns ((amount)(admins)) within that column group. I would like to have admins hidden in the detail, but have it still show the subtotal.this is what i have now:Bars (row group)--------------REV (column group)-----------amount (total)-----------admins(total) ---------------------Amount (column) ------------------------- admins (column)---------------------11-------------------- $1,225 ------------------------------------ .36% --------$1,225 (total)------------- 0.36% (total) Total---------------- $1,225 --------------------------------------- 0.36% -----$1,225 (total)------------- 0.36% (total)This is what I want:Bars (row group)--------------REV (column group)-----------amount (total)-----------admins(total) ---------------------Amount (column) ------------------------- (hidden)admins (column)---------------------11-------------------- $1,225 ------------------------------------ (hidden).36% --------$1,225 (total)------------- 0.36% (total) Total---------------- $1,225 --------------------------------------- (hidden)0.36% -----$1,225 (total)------------- 0.36% (total)does that help? |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2009-04-02 : 11:17:33
|
| I've found the answer. In textbox properties > Visibility > Expression > =inscope("matrix1_your column group"). This will do the trick. The only problem I'm having now is how to eliminate the white space where data is hidden. Any suggestion? Thanks. |
 |
|
|
bmiddleton74
Starting Member
5 Posts |
Posted - 2009-04-22 : 22:02:22
|
quote:
Originally posted by huynhtl
I've found the answer. In textbox properties > Visibility > Expression > =inscope("matrix1_your column group"). This will do the trick. The only problem I'm having now is how to eliminate the white space where data is hidden. Any suggestion? Thanks.
Did you solve this? I'm having the same problem. |
|
|
|
|
|
|
Hide column in detail