I am using Report Builder 3.0 to create an SSRS report.
I am using three parameters for dynamic grouping.
The first paramater is
Prompt First Sort
It is text and visible
There are two more parameters named SecondSort and ThirdSort with the same setup.
I have Available values of
Label Plant Value Plant
Customer Name Name
Product Code ProdCode
Everything works great, but, when the report is run and you make the run-time selections, they always show the same three prompts.
Is there a way that when you select the first prompt, the second prompt will only show the two prompts that have not been used and the third prompt will only display the last, unused value.
That is, if my First Sort is Customer Name, the Second Sort will only show Plant and Product Code. And if the Second Sort is Plant the Third Sort only shows Product Code.
Thank you in advance