| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2012-01-29 : 23:18:02
|
| New to the Reporting Services and never got exposed to neither create / modify the reports, as some has already created the reports and now I need to 'locate the query from these reports which is running in SQL Server 2005.I could able to see the reports and able to execute but couldn't go to the EDITOR from where I can grab this query based reports.Many thanks for your support help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-30 : 11:42:45
|
| do you've access to report manager? or you at least have report files stored in some repository?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-01-30 : 15:58:38
|
| Thanks for getting back to me, We have the Report server and able to get see through the Query from the Database driven table called Catalog. The path as: '/Data Analysis Reports/Data Sources/Reports - Mirage'.I dont have idea how to get into this PATH from this server.Alternatively, Could you give step as to where I should START to get to see the Basic things from to view the SQL Query Code.Sorry for this since I am totally new to Access the Reports.Thanks Again. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-01-30 : 17:50:58
|
| http://reportsvr2005/Reports/Pages/Folder.aspx is the Portal address.But couldn't succeed in getting the Query Content on getting inside the reports Generation / Execution.In other words, I can execute by giving necessary parameters but couldn't get the QUERY which was used for this report.Any Help many thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-01-30 : 18:15:51
|
I am not able to see the Trace to run since I am Junior in team and senior DBA's were on Holidays .Since new to this, just need to get the queries for the background of this report(s).Thanks Again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-01-30 : 18:30:20
|
| Unfortunately No. But I need to get the Query only.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-30 : 19:47:32
|
quote:
Originally posted by dbalearner
http://reportsvr2005/Reports/Pages/Folder.aspx is the Portal address.But couldn't succeed in getting the Query Content on getting inside the reports Generation / Execution.In other words, I can execute by giving necessary parameters but couldn't get the QUERY which was used for this report.Any Help many thanks.
you dont have access to export reports from report manager?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2012-01-30 : 20:11:48
|
| I could able to Export the data but not Query part. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Fetch Query from Reports