Microsoft Idea

377

Report Inspector

Steven Renders on 3/16/2019 10:00:56 AM

Similar to the page inspector, we would like to have a report inspector.

The report inspector should allow us to see:
- The ID and Name of the current report
- The current selected layout (ID, Name, Type) of the report
- The Dataset, it's values, and applied filters, of the current report
- Any errors that prevent the current report from running (currently there's no error info available when something goes wrong.)
- The ability to export the dataset (to xls, xml,...), so it can be analysed

STATUS DETAILS

Completed

Business Central Team (administrator)

Thank you for your feedback. We have built a feature in 2021 Wave 2 that supports saving report dataset to Excel, either for use by developers, consultants or power users as part of developing report layouts (i.e., similar to About this Report known from the Windows client, but in Excel instead), or for use by end customers to export report data to Excel for further processing, e.g., filtering or pivoting. This feature can be tried out in the insider build artifacts already for vnext/v19 (use "Save as Microsoft Excel (data only)" option in report request page), but as we plan and hope to also backport this to a 2021 Wave 1 minor (currently targeting v18.3) due to demand and usefulness, this idea is marked for April 2021 release for now.

Update July 6th 2021:

We have shipped this in Minor Update 18.3. See Docs for more: Working with Reports, Batch Jobs, and XMLports - Business Central | Microsoft Docs

Peter Borring

Program Manager, Microsoft 

Comments

RE: Report Inspector

Jörg Brugman on 8/17/2019 4:29:25 AM

This feature is absolutely necessary for professional report-desing! Please implement it as fast as possible!