Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Trying to find what query is run for a GP 2012 native report

(0) ShareShare
ReportReport
Posted on by 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 

pastedimage1670267250189v1.png

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?

Categories:
  • merrittr Profile Picture
    merrittr 65 on at
    RE: Trying to find what query is run for a GP 2012 native report

    Yeah I tried profiler that was a dead end. it is like GP is masking so you cannot find the query ...this is a really good reasonn to steer clear of DYNAMICs is this is a way to trap people

  • Suggested answer
    RE: Trying to find what query is run for a GP 2012 native report

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans