SSRS Report & Query

Question

Post reply

SSRS Report & Query

ramana3327

SSCoach

Points: 19722
More actions
September 8, 2014 at 1:58 pm

#397316

Hi,
How to find the query that is generating the Report from the ReportMangerURL.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63512 More actions · Answer 1

Easiest way to do it is to open the report in design view. Do you not have rights to do that?

ramana3327 SSCoach Points: 19722 More actions · Answer 2

Hi,

Thanks you are thinking that Visual studio.

I am not asking from Bids where you created the report. If some one upload the report to folder using report manger url. You have full access on that report manger then When you have the report in folder under the reportmanger url, how to find that query

DBA in Unit 7 SSCarpal Tunnel Points: 4059 More actions · Answer 3

Go to the PROPERTY of the report; in the Report Definition, click EDIT, you will open an RDL file from within which you can Search For QUERY in the RDL to get the query.

ramana3327 SSCoach Points: 19722 More actions · Answer 4

Got it. We have to click on the download. Then if we open the rdl, we can find the query