locked
reporting and store procedures. RRS feed

  • 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,

    Thursday, August 11, 2011 11:02 AM

All replies

  • User-305876627 posted

    use Subreport.

    you can have multiple reports using subreports.

    Wednesday, September 7, 2011 5:07 PM