Can someone show me how to remove blank columns from a matrix report with parameters?
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 Column2 Column3 [quote][/quote] Column4 Column5
November 20th, 2010 12:37am
Hi, You could control the whole matrix's visibility by setting the expression =IIF(CountRows("ScopeName")), then if ther is no recored in the dataset, the whole matrix will be hiden. If I misunderstand you, please feel free to let me know. Thanks, Challen Fu
November 22nd, 2010 3:27am