How to access SSRS multivalue parameters by their array index value

Hi,

How can I refer to an SSRS multivalue parameter by its index value?  Let's say I have a list
of 10 multivalue parameters that reference database column names.  If the user selects the
2nd and 3rd item from the list,  I would like to build a dynamic SQL query including just
those items.  I'd like to be able to build a string something like this:

"SELECT "+IIF(Paramters!Columlist.value(1) <> null,Paramters!Columlist.value(1),"")
  +IIF(Paramters!Columlist.value(2) <> null,Paramters!Columlist.value(2),"")+ ETC...

I know I can test if a value was selected this way:
 instr(Join(Parameters!ColumnList.Value,","),"aColumnName")=0
But the column names are MDX tuples and can be quite large and I think this will not be efficient.

Is there a way to use the array index, how best to do this?

THanks

 


March 27th, 2015 4:09pm

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

Other recent topics Other recent topics