Sharing dataset between controls in SSRS 2005

  • My report has two table controls.

    Both Tables are satisfied by a single dataset (A stored procedure)

    I want to know whether while rendering whether the stored procedure will be executed twice or will be execution results be shared between the controls.

    My access is limited cant run a profiler trace to find out. Welcome your suggestions

    Thanks

    Bala

  • Hi Bala,

    Interesting question. I've tested this on one of my reports that shares a dataset between a matrix and a table and profiler prooves that the dataset is only executed once.

    Hope this helps.

    Kind regards,

    Linda

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

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