Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Sharing dataset between controls in SSRS 2005 Expand / Collapse
Posted Wednesday, January 12, 2011 4:32 PM


Group: General Forum Members
Last Login: Friday, September 11, 2015 12:15 AM
Points: 22, Visits: 120
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

Post #1046906
Posted Thursday, January 13, 2011 1:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 1, 2014 4:54 AM
Points: 26, Visits: 56
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,

Post #1047054
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse