| Author |
Topic |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2008-05-28 : 04:40:30
|
| Hello,I have a matrix with subtotal.I want to hide or show the subtotal by a parameter.The header of the subtotal is not a problem since it have the "visibility" property.The problem is that when I'm clicking on the green rectangle to go to the subtotal area itself - It doesn't have the "visibility" property.So I don't see the header but I see the subtotal date itself.Any idea on how to resolve this? Thanks. |
|
|
Johnho008
Starting Member
24 Posts |
Posted - 2008-05-28 : 05:43:09
|
| I am new to reporting services too but the only way I can think of is by changing the colour of the text. You can try a IIF expression on the text colour property so that if your parameter =true, black,white(or whatever colour as your background is) |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-05-28 : 06:32:02
|
| Hi.I thought about it but its really a bad idea.It mean to change the font color, background color and border style.Its look like too much work.The header have a "visibility" property, only the "subtotal" itself don't.Thank for the replay. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 07:17:27
|
quote:
Originally posted by roy mm
Hello,I have a matrix with subtotal.I want to hide or show the subtotal by a parameter.The header of the subtotal is not a problem since it have the "visibility" property.The problem is that when I'm clicking on the green rectangle to go to the subtotal area itself - It doesn't have the "visibility" property.So I don't see the header but I see the subtotal date itself.Any idea on how to resolve this? Thanks.
There's not a subtotal column physically existing for matrix. It actually renders the column dynamically using data from detail rows. |
|
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2008-05-28 : 09:24:21
|
| [/quote]There's not a subtotal column physically existing for matrix. It actually renders the column dynamically using data from detail rows.[/quote]Ya, Thats the problem.So I'm guessing from your answer that there isn't any way to control this at run time with parameter?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 10:11:36
|
quote:
Originally posted by roy mm
There's not a subtotal column physically existing for matrix. It actually renders the column dynamically using data from detail rows.[/quote]Ya, Thats the problem.So I'm guessing from your answer that there isn't any way to control this at run time with parameter?Thanks[/quote]Not sure it works, but just a stab in darkCan you try putting a expression in the hidden property of detail row of matrix like this=IIF(Inscope("YourDatasetNameHere"),False,IIF(Parameters!YourParameter.value="Your Visibility value",False,True)) |
|
|
|
miaolo
Starting Member
1 Post |
Posted - 2009-07-02 : 00:24:09
|
| Hi All, I have some problem with mr. roy mm. I wanna hide a subtotal row using the parameter. I have some subtotal, example: subtotal1, subtotal2, subtotal3, and the grandtotal. which is :* the subtotal1 (in smallest group, group name: group1) is still in subtotal2 scope, * the subtotal2 (group name: group2) is still in subtotal3 & grandtotal scope, * and subtotal3 (group name: group3) is still in grandtotal scope.but, I just want to hide only subtotal2 using this parameter.If I implement the code below:-> ' =IIF(Inscope("group2"),False,IIF(Parameters!YourParameter.value="Your Visibility value",False,True)) ' in hidden property Then, It will hide not only subtotal2, but also subtotal3 and grandtotal. What I want is It just only hide the subtotal2, and subtotal3 & grandtotal will appear normally.The mostly big question for me offcourse is :I can't figure which number in the detail or in total (subtotal/grandtotal). and also I can't figure that it's only in subtotal2 and not in subtotal1, subtotal3 or in the grandtotal area. can't anyone help.. Thank's before |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-02 : 12:54:42
|
| have you tried something like?=IIF(Inscope("group2") Or Inscope("group1") Or Inscope("group1"),False,IIF(Parameters!YourParameter.value="Your Visibility value",False,True)) ' in hidden property |
|
|
|
|
How to hide subtotal