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.
UPDATE 28/03/2012:
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
=IIF(Fields!SessionIdentifier.Value="AD","AD",Nothing)
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.