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
- Edited by billywinter 10 hours 57 minutes ago