Search code examples
reporting-servicesssrs-2008

Make Tablix Column group show when filter returns no rows - SSRS

I am working on some SSRS reports and am running into an issue where Tablix Column groups drop from the table when the filter returns no rows.

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

Am I just missing a simple option?

Solution

  • Maybe add a

    UNION SELECT '', n ..., '';

    clause to your report query? It's ugly but should work. If you go this route, add a comment for your colleagues (or your future self) that will have to maintain the report.