Reporting services TIP #10

05/02/2009

תגיות: , , ,
אין תגובות

Hi all,

I decided to blog each time I run into nice trick at the BI services.

I have counted 9 tips, so I will numerate them… ( just for fun)- it is always good to start from 10. (-:

Problem:

You have a table. you need to hide/unhide columns by specific parameter.

For example:

You have this table, you need to hide the Qi columns by a value of the parameter.

 

site Q1 Q2 Q3 Q4
a        
b        
c        
d        

 

Solution:

Past this expression on each column visibility:

IIF(INSTR(Join(Parameters!StatementName.Value, ","),"x")0,False,True)

Change the parameter name to your parameter, change the x to the appropriate condition ex. "Q1".

Now, when you choose the Q1 parameter, only Q1 column will be seen, the other will be on hidden state.

 

Bye,

Ronen

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *