I have a drilldown matrix report with 5 parameters that I group on. The users have the option of selecting any of these parameters when they preview the report. They can also select No grouping as one of the parameter option. When I run the report and select for example, 4 parameters and the No grouping option, I get blank columns. When I select no grouping, no data is displayed. As a result, I get blank columns. Is there a way to hide the blank columns? I would appreciate any suggestions. See table example below:
Parameter1, Parameter2, Parameter3, Parameter4, No grouping
Blank columns example:
Column1 Column2Column3
Column4 Column5