Post reply

Any way to set the *order* that datasets are run?

  • April 6, 2010 at 7:47 am

    #220987

    I'd like to run my stored procedure dataset first, then have a second dataset SELECT from a table populated by the stored procedure. (The stored procedure also returns a dataset).

    Is it possible to tell the report to run the sproc before the SELECT?

    Thanks!

  • April 8, 2010 at 2:08 pm

    #1148641

    worked around it.

  • April 9, 2010 at 5:34 am

    #1148970

    For others with the same questions, here are some points of note:

    > only 1 dataset is returned to ssrs

    > cannot really set the order of operations unless there is a dependency on parameter input.

    > however, within your sproc you can do all sorts of work, even CRUD operations before returning your dataset

    > if you absolutely need to join info from 2 different datasets at runtime, currently this is a PITA and requires code behind. But in 2008 R2, new native LOOKUP functions will make this much much simpler to implement.

    SQLScrubs: SSRS Audit, Optimization & Management reports

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply