reporting and store procedures.

Question

User-309740890 posted

Hi, I have a report that executes a store procedure and returns member ids based on the sp. It works, my question is it possible to execute another sp after and run the second sp based on the output from the first sp?? If yes, how? provide an example if you know how.

maybe, store data into a temp table after run the first sp and execute the second sp and use the temp data? is it possible...?? the goal I am trying to accomplish is to have 2 reports,

Thanks,

Answer 1

User-305876627 posted

use Subreport.

you can have multiple reports using subreports.