I have a Stored Proc in my report. I also have a dynamic SQL. There is no way to map these two data sources. But the dynamic SQL requires one of the parameters that is neing used for Stored Proc. I am unable to assign the same parameter to both these datasources. So I created a new parameter and assigned the existing parameter used in Stored Proc.
I use the static parameter option for the new parameter and in the default value option passed {?existing param}. The report works but the result from the dynamic SQL is empty. When I hardcode the value to be passed, my SQL works. So not sure if this reassigning the param works.
Thanks,
Kiran
IP Logged
