I believe you need Parameters, Calculated Items, and some Controls to populate values of Parameters
[Calculated Item 1]
IF ('parameter 1'p = 'Column name 1')
RETURN 'COLUMNNAME1'n
ELSE
IF ('parameter 1'p = 'Column name 2')
RETURN 'COLUMNNAME2'n
ELSE.
.
. .
IF ('parameter 1'p = 'Column name N')
RETURN 'COLUMNNAMEN'n
[Calculated Item 2]
IF ('parameter 2'p = 'Column name 1')
RETURN 'COLUMNNAME1'n
ELSE
IF ('parameter 2'p = 'Column name 2')
RETURN 'COLUMNNAME2'n
ELSE.
.
. .
IF ('parameter 2'p = 'Column name N')
RETURN 'COLUMNNAMEN'n
Fill each one of Controls with a Table of size 1xnames_of_columns_to_choose_from (in other words a variable made out of all column names)
Hope it helps
Konrad
... View more
