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

stored procedure for ssrs 2008 r2 report Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 1:26 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
I am working with a visual studio ide for SSRS report 2008 r2. I would like to see what stored procdure is executed for the report. However while I am in visual studio, I do not know how find the stored procedure. Thus can you tell me what to click on so that I can find the stored procedure behind a report?
Post #1416063
Posted Tuesday, February 5, 2013 2:05 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:33 AM
Points: 21,190, Visits: 14,881
You can look in the datasets for that report. You would typically see those on the left hand sand from within BIDS (Vis. Studio)



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1416090
Posted Tuesday, February 5, 2013 6:41 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
When I am using bids, I do not see the dataset on the left side of the visual studio ide. Can you tell me how to display the dataset?
Post #1416197
Posted Tuesday, February 5, 2013 11:12 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:33 AM
Points: 21,190, Visits: 14,881
If you do not have the report data window visible (either as a tab or as a window within bids), then click view and then click report data (at the bottom of the view menu).

This will show the report data window. There will be a data sets section with a + in that window.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1416250
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse