Thank you Alex - once the user selects the value (using the slider in your example), I want to go to a separate worksheet (via an action) and have the parameter's value persist so the custom SQL for the target worksheet only brings back the rows that match the value (where clause) ... is that correct?
1 of 1 people found this helpful
The action thing complicates it - not sure how that will work. Either way, you can't change the value of a parameter in any way apart from using the parameter dialog box or control.
Looking at this a different way - why use the parameter at all? Why not just bring in all the data then filter?
Thanks again Alex for the timely reply - I started down the path of bringing in all the data but even with extracts and Teradata as the heavy-lift engine, there is a LOT of data to bring back. I was hoping to use the parameterized custom-SQL to bring back the (smaller) subset of the data based on the user's selection from the parameter control.
I'd appreciate one last post on any helpful tips. thank you