How to make a column invisible in an ssrs matrix

问题:

I have an ssrs matrix , the design of which looks like this :

The sql query used in the above dataset looks like this :

select [YEAR], [MONTH] as MONT , ProductName, NumberofSales from XYZ ;

When the report is run , My output looks like this :

Here , the Column Names 9 , 10 correspond to the months 9 - September and 10 - October.

Change shows the difference in numbers between the month and the previous month . example : number of sales in october - number of sales in september.

I would like to remove the column that I have circled in the above picture . Could you please let me know how I can do this . ??

I already tried right clicking the Change column and changing the visibility property, by adding an expression to look soomething like this :

=(Parameters!UserSelectedDate.Value=Fields!MONT.Value)

But that gives me an entire blank space for the Change column like this :

But I do, not want to see the blank space. I would like to remove the column completely. Please let me know if it is possible.

回答1:

I don't know, why it shows blank space, but here is how I handled this problem:

1. Choose "column visibility" property of column "Change"
2. Then I added expression for hiding column: =IIF(Month(Fields!Date.Value)=Parameters!UserSelectedDate.Value,True,False)

And when I select report parameter to 1 and preview the report, it hides Change column for month 1:

回答2:

This answer works only for matrixed (varied count) columns. But in all reports client want to group report data dynamicly and select column that one want to see. So if I have matrix for example with columns -

[Store] [Good] [Amount Jan] [Amount Feb].... [Amount Dec]

I can hide any column with Amount but If I right click on column Store - No option in menu- Column properties and option Column Visibility - Disabled. If apply visibility to cells - you'll see a blank space.