Is there a way to see the SQL query that is behind a report? I am trying to get the sql query of a specific report so that i can format it differently as the current format doesn’t help me at all for the type of report i want to do. It’s a stock position report.
Normally I would say run “SQL Profiler”.
But which version of Dynamics NAV and SQL Server are you using?
HI,
IF I am not wrong are you using a 2009 or Higher Version and you are talking about RTC Reports.
Where you see a Dataset already created in VS / Report Builder. Now you want to see how that dataset is created.
IF that is correct , then its not possible as per my analysis. I have spent good amount of time on that. That is somewhere in DLL which generates that DLL. I think so.
I think you also know how to develop SQL Reports, so you are looking for it 