About JOIN: Can I pass the parameters from the 2nd report to the primary report?

[lookingforK]

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.