Make Tablix Column group show when filter returns no rows RRS feed

  • Question

  • I'm running SQL Server 2008 Feb08 CTP and I've got a tablix with column groupings and row groupings which works nicely, I'm a becomming a big fan of the tablix.


    However sometimes the filter I have on a column group returns no records and the whole column group disappears.

    Is there any way to make this column appear with but with empty cells as I have another tablix down the page with the same columns and I want the columns to all line up on the multiple tablix.


    In Version 2005 I used to achieve the equivalent of a column group within a table by adding a list with filter to the cell, this meant the column always was shown, the tablix allows does this much more elegantly but I'll have to go back to the old method if I can't make the column remain.


    Am I just missing a simple option?




    Tuesday, May 20, 2008 11:47 PM