Hi,
I am using Report Studio 8.4.1.
I want to combine data from 2 different relational packages. I plan to do so by including (e.g. JOIN) a query on the primary report. The query for JOIN is sourced from a Native SQL based on the 2nd report.
The problem is: The 2nd report for providing the Native SQL includes several parameters (using #prompt# function). When I use "Show Generated SQL/MDX" to generate the Native SQL, the parameters can't be there and they are changed to the values I select from the prompts before the SQL is generated.
Can I pass the parameters from the 2nd report to the primary report?
So I can select the parameter values of the 2nd report on the primary report.
Thank you in advance.