Dynamic data set parameters during report run time

I need to pass the out put from a stored procedure as an input parameter to another stored procedure. I created a data set for each stored procedure. Fron the second data set parameter tab, I added a parameter to refer to the field from the first data set.

I get the error Fiels can not be used in query parameter expressions.

I tried two simple queries instead of stored procedures with first query feeding the second query. I get the same error. Is there any other other way to accomplish this?

Thank You.

Hello,

Are you trying to have a report parameter that is populated from one stored procedure and the data in the report is populated from another stored procedure?

Jarret