How to see dataset in Business
We used to
have “About this Report” option to export the dataset of the report to
inspect the data that is generated by a report dataset in earlier Dynamics NAV versions.
This was very useful to filter the reports and optimize the dataset performance.
new feature that does similar to above functionality from D365 Business Central
version 18.3 onwards. This new feature exports report dataset to Excel.
Open the feature management page.
Step 2: By default, all the features are not enabled. Select the feature (Export report dataset to Microsoft Excel document)
We need to enable the feature by changing the value of Enabled for from None – All
Refresh the environment for reflecting the new changes.
Now, open Posted Sales Invoices page and then try to print the report for any
In the request option page select “Send to…” option
In the given “Choose file type…”, select “Microsoft Excel Document (data only)
option and click “OK” to download the dataset to Excel document.
Step 8: Now,
open the downloaded excel document to view the dataset.
To view the developed layout with the data select another option “Microsoft
Excel Document (data and layout)” and click OK.
Open the downloaded excel file to see the report output with the developed RDL