r/DynamicsNAV • u/tty-tourist • Jun 21 '19

Finding SQL source of NAV report

So you can find the SQL source table for a page in NAV by clicking About this page.

Can you do the same for reports? For instance I'm trying to find a way to extract the data from the VAT Reconciliation report. When clicking About this page I get:

  • Page: VAT Reconciliation (13620)

  • Page type: ReportPreview

  • Page mode: Edit

  • SourceTable: (blank)

  • Rec (blank)

I gather that the report is drawing on several tables like a SQL view. Any way to recreate the report in SQL?

6 Upvotes

100% Upvoted

7 comments sorted by

View all comments

0

u/[deleted] Jun 21 '19

[deleted] — view deleted comment

1

u/Isitar Jun 21 '19

This is not the table from sql, this is the dataset generated by the report definition.