I am trying to use 2 prompts in my report from the first prompt (multivalue) I select the column name, and the
second Prompt (multivalue) should show the distinct values for the column selected in the first prompt, I am able to do this by using union all and using a if clause, but then it does not work when I select only one Column name in
the FIRST prompt.
The code is like this:
" select " & Parameters!col_name.value & " as col_heading from mytable "
"select " & Parameters!col_name.Value(0) & " as col_heading from mytable " &
" union all select " & Parameters!col_name.Value(1) & " as col_heading from mytable "
Any help on this.
View Complete Post