please make it disappear

[clamcc]

Hi,
I'm using a matrix that is a roster of student rows with columns of their test scores. The problem is with those students who do not have any test scores. Those students "create" a blank column. Is there any way to make that column disappear? I can't find a visibility property.

 

[Crowley16]

surely it would be better to filter out these students from the underlying dataset?

--------------------
Procrastinate Now!

 

[clamcc]

No, it would not. These are to be class rosters and the teacher will expect to see the names of all the students in the class regarless of whether they took the test or not.
I was able to make the blank column disappear as long as some of the kids took tests with these instructios:
Matrix Visibility
Select the matrix & right click for properties


Select the Groups tab
Edit the column Grouping
Click Visibility tab

this is the expression that let me hide the empty column
=IIF(IsNothing(Fields!Assessment_Hdr.Value),true,false)

edited the other column Grouping as well
=IIF(IsNothing(Fields!Score_Type.Value),true,false)


But if the whole class didn't take any tests, I still get a blank column.