Sharing dataset between controls in SSRS 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Sharing dataset between controls in SSRS 2005...

Sharing dataset between controls in SSRS 2005

Rate Topic

Display Mode

Topic Options

Author

Message

bala705

Posted Wednesday, January 12, 2011 4:32 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 3:00 PM
Points: 22, Visits: 110

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

Linda Claes

Posted Thursday, January 13, 2011 1:43 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:03 AM
Points: 26, Visits: 53

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 »

Permissions