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 |
|
SeanL
Starting Member
3 Posts |
 Posted - 2009-10-29 : 05:16:49
|
| hi,Im having a little issue with a matrix report. I want to hide the row when the Total is 0 or Null. The problem is that when I right click the details row, the "row visibility" option is greyed out.Matrix is layed out as followsCompany - Group 1Client - Group 2Detail Row : with Groups: Rank; Account Code; Account Description---Group 1 and 2|| -- Group 3, 4 and 5, and detail|| ||| -----The columns basically contain all the clients branches with a total column on the end |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-30 : 13:46:50
|
| Select the whole matrix and do:Properties, Groups, and then the row group you want to changeJohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
SeanL
Starting Member
3 Posts |
Posted - 2009-11-01 : 23:07:56
|
| If i select the whole Matrix, and do properties, only options are General, Visibility, Filters and Sorting.... no groups.. am i missing something? |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-02 : 16:44:54
|
| You must not be selecting the whole Matrix. Since I do not have designer at home, my "from memory" just is not accurate enough... SorryJohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|
|
Reporting Services - Hiding Rows with Null or 0