I have created a report for SSRS 2008 which produces the results below.
What I am looking to achieve is for those results in pink, AD, to be under both AM and PM with the text centered i.e. merged cells.
The weekdays and AM/PM are group headings in a matrix based on fields in my table. To display the data I am using a table within the data region of a matrix.
I've read other posts about creating an additional row in the table which has 2 cells merged together, using an expression to hide this row when it is not used though I've not managed to get this to work correctly.
I've managed to get the AD to appear under both AM and PM. What I did was remove the AM/PM column group and create 2 cells under the Weekdays group and input the text AM and PM in these cells. I then created 2 rows in the data section of the matrix with the bottom row having 2 columns. In each of these cells there is a table with the expression
and the row visibility in each table is set using an expression:
=IIF(Fields!SessionIdentifier.Value="AD", False, True)
What I would like to do now is hide the top row in the data region of the matrix when it is empty but I haven't figured out the expression to do this.