Collapsing empty columns in RS 2008 Martix
Hi! I have got a couple of column in martirx report in RS 2008 which don't have any values. Is there are way to collapse them so I won't see empty columns in my matrix? Thanks for any help! donnie100
April 13th, 2011 2:11pm

Hi If you dont have any values. just don't select it in report. You can omit it by SQL query/Stored proc itself or just dont select it in matrix Regards, Amey
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 4:55am

Hi! I have got a couple of column in martirx report in RS 2008 which don't have any values. Is there are way to collapse them so I won't see empty columns in my matrix? Thanks for any help! donnie100 From your statement, I get that you do not want to display the column in which all the value is null, right? If so, I would recommend you follow below detail steps: 1. Right-click the ColumnGroup Name in Column Groups pane located in bottom-left corner, and then select Group properties... 2. Move to Visibility tab, then select the Option of Show or hide based on an expression in the right diagram. 3. click FX button to type in below expression =IIF(IsNothing(SUM(Fields!Data.Value,"ColumnGroupName")),true,false) Note: Data and ColumnGroupName is your data field and Column group name, you should replace them based on your report. 4. Click OK. After these steps, I think you could get what you want. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
April 18th, 2011 3:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics