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 |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2013-07-17 : 06:18:40
|
| Hello all,In my Matrix I show a SubTotal (right click for the last row Group) to show the totals, but I'd like to hide it if I got only one record. Is it possible to perform this? Thanks in advance. Luigi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-17 : 07:13:49
|
| Yes. Write an expression for the hidden property of the column. something like=IIF(CountRows("GroupName")=1,True,False)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-07-17 : 10:11:03
|
| Thank you very much Visakh.Luigi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-17 : 11:15:51
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Hide SubTotal for only one record