65
I have some old native reports our finance department run that I would like to migrate to SSRS , easiest way for me to do this is to get the query/queries that grabs the data behind this report for example
I run this while watching/capturing the queries run agains the mssql database server that the mgmmt report is using is there a better way for me to see what tables/views are beining queried?
There's not a way to do that, that I'm aware, such as getting a query to pull data that a MR report is using, to then use it to setup a SSRS report or something along those lines.
You could maybe look at a SQL profiler trace when running a report from MR to see what that shows. If using legacy you might see queries that you could use, but if using data mart, less likely.
That being said, I'm not sure either would show you anything useful.
Maybe others in the community have something they have done or used?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (