How can I determine the Stored Proc used on an SSRS page?

B. Clay Shannon

We have an SSRS Report Server (I don't know if the name "Report Sever" is peculiar to us or common to SQL Server report services (IOW, I don't know if we chose it, or Microsoft did)) that hosts various queries that users can run against our data.

I need to find out which query is being run, probably which Stored Proc, for a given report that is available.

I thought I could suss that out via the "View Source" from the page, but I see no "data source," nor the name of our connection, or such. In fact, I looked through the entire source and saw nothing helpful.

The "View Report" button is:

<td><input type="submit" name="ReportViewerControl$ctl04$ctl00" value="View Report" id="ReportViewerControl_ctl04_ctl00" />

...and the only other reference to it is here:

Sys.Application.add_init(function() {
    $create(Microsoft.Reporting.WebFormsClient._PromptArea, {"CredentialsLinkId":"ReportViewerControl_ctl04_ctl01","ParameterIdList":["ReportViewerControl_ctl04_ctl03","ReportViewerControl_ctl04_ctl05","ReportViewerControl_ctl04_ctl07","ReportViewerControl_ctl04_ctl09"],"ParametersGridID":"ParametersGridReportViewerControl_ctl04","ReportViewerId":"ReportViewerControl","ViewReportButtonId":"ReportViewerControl_ctl04_ctl00"}, null, null, $get("ReportViewerControl_ctl04"));
});

Is there a way, either from the "View Source" or otherwise, where I can coax out the SP used to generate the report?

UPDATE

Spurred on by Steve Mangiameli's comment, I see that I have the following in my Start menu:

MS SQL Server 2005
    SQL Server Business Intelligence Development Studio (BIDS)
MS SQL Server 2008
    SQL Server Installation Center
MS SQL Server 2012
    SQL Server Data Tools

I don't know which, of any, of these has value for me in this quest.

UPDATE 2

We do have a Visual Studio 2005 project named "Report Server" project with many .rdl files beneath the "Reports" folder. I thought this was a unique-to-us solution, but maybe not.

Even if this is the "Report Server" mentioned, though, I still don't know which .rdl file is the one that drives the report I can generate via our online Report Viewer page.

It would be nice if the report, when generated, had some reference to the name of the related .rdl file.

Steve Mangiameli

You're going to want to navigate either Report Manager or the Report Server to download the report. Once you have the .rdl file, open it in a text editor...it's just an xml file. Simply perform a find for "dataset" and inspect the dataset values. You will see the datasource, parameter and SP. Use this link to help you navigate the site.

Adding a better link with pictures. I'd do it myself but don't have access to cloud services here at work.

http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

How can I specify a Stored Procedure to be used in the SSRS Report Wizard?

From Dev

How can I used VBA to determine whether the code is in break mode

From Dev

How can I efficiently determine the most used color?

From Dev

How can I determine what key is being used by an SSH command?

From Dev

How can I determine what key is being used by an SSH command?

From Dev

How can I efficiently determine the most used color?

From Dev

How can I determine the connection method used by a MySQL client?

From Dev

How can I determine which SSH keyfile was used to authenticate a login?

From Dev

How can I determine the exact value used for a media query?

From Dev

How can I determine the page number of a table in MS Word Macro?

From Dev

How can I display an image stored in a database on a php page?

From Dev

How can I query my Database for any Stored Proc that returns a field/column value of a specific name?

From Dev

Can I use Visual Studio to track changes to tables and stored proc?

From Dev

How to determine obj can be used in for loop

From Dev

How can I determine what log configuration source Logback actually used?

From Dev

How can I determine the algorithm used for hashing passwords in a Grails app using springsecurity?

From Dev

How can I determine which Windows DLL is being used for a function call?

From Dev

How can I determine which version of Excel was used to create a .xls file?

From Dev

How can I determine the algorithm used for hashing passwords in a Grails app using springsecurity?

From Dev

How can I determine what is causing the used disk space to slowly increase in Linux?

From Dev

how to determine a page(or file) is least used.how to determine calculate method,which is about Least Recently Used

From Dev

How can a stored proc have multiple execution plans?

From Dev

How can I set up the SQL Server permissions to make SSRS utilize a stored procedure rather than an embedded query?

From Dev

How do I determine the number of items I have stored in an array?

From Dev

How can I determine if a jquery click in one section of the page is related to an element?

From Dev

How can I determine the length of a multi-page TIFF using Python Image Library (PIL)?

From Dev

How can I determine the page count of odt, doc, docx and other office documents from the CLI?

From Dev

How can I determine the page count of odt, doc, docx and other office documents from the CLI?

From Dev

How can I determine if a jquery click in one section of the page is related to an element?

Related Related

  1. 1

    How can I specify a Stored Procedure to be used in the SSRS Report Wizard?

  2. 2

    How can I used VBA to determine whether the code is in break mode

  3. 3

    How can I efficiently determine the most used color?

  4. 4

    How can I determine what key is being used by an SSH command?

  5. 5

    How can I determine what key is being used by an SSH command?

  6. 6

    How can I efficiently determine the most used color?

  7. 7

    How can I determine the connection method used by a MySQL client?

  8. 8

    How can I determine which SSH keyfile was used to authenticate a login?

  9. 9

    How can I determine the exact value used for a media query?

  10. 10

    How can I determine the page number of a table in MS Word Macro?

  11. 11

    How can I display an image stored in a database on a php page?

  12. 12

    How can I query my Database for any Stored Proc that returns a field/column value of a specific name?

  13. 13

    Can I use Visual Studio to track changes to tables and stored proc?

  14. 14

    How to determine obj can be used in for loop

  15. 15

    How can I determine what log configuration source Logback actually used?

  16. 16

    How can I determine the algorithm used for hashing passwords in a Grails app using springsecurity?

  17. 17

    How can I determine which Windows DLL is being used for a function call?

  18. 18

    How can I determine which version of Excel was used to create a .xls file?

  19. 19

    How can I determine the algorithm used for hashing passwords in a Grails app using springsecurity?

  20. 20

    How can I determine what is causing the used disk space to slowly increase in Linux?

  21. 21

    how to determine a page(or file) is least used.how to determine calculate method,which is about Least Recently Used

  22. 22

    How can a stored proc have multiple execution plans?

  23. 23

    How can I set up the SQL Server permissions to make SSRS utilize a stored procedure rather than an embedded query?

  24. 24

    How do I determine the number of items I have stored in an array?

  25. 25

    How can I determine if a jquery click in one section of the page is related to an element?

  26. 26

    How can I determine the length of a multi-page TIFF using Python Image Library (PIL)?

  27. 27

    How can I determine the page count of odt, doc, docx and other office documents from the CLI?

  28. 28

    How can I determine the page count of odt, doc, docx and other office documents from the CLI?

  29. 29

    How can I determine if a jquery click in one section of the page is related to an element?

HotTag

Archive