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
Author
Message
Posted Wednesday, January 12, 2011 4:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, May 25, 2014 6:28 PM
Points: 22, Visits: 112
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
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,

Linda
Post #1047054
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse