Hi,
I am using commands for providing values for dynamic parameters and then using stored procedure passing these parameters in. Are all commands executed at the same time for all parameters? I guess they are, I just need the confirmation as I am probably wasting my time trying to find solution to my problem. I am trying to use the values provided in the date range parameter (1st parameter) as additional selection criteria for the following parameters. I've tried several solutions but nothing seems to work. It looks as though the values for input parameters are retrieved even before the prompts appear and it is not possible then to refresh the following list based on the value of the previous parameter. Can someone, please, say if it is possible at all ?
Thanks