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

Julian Tillmann on 6/28/2021 6:34:50 AM

@Stephen Renders @Microsoft
How does it work and where can I find any documentation about it?

Category: Reports and Business Intelligence

RE: Report Inspector

Steven Renders on 6/4/2021 7:29:28 AM

Awesome!!!

I have tried it in the preview and it works really really great!

A very big thank you! :-)

Category: Reports and Business Intelligence

RE: Report Inspector

Steven Renders on 2/25/2021 9:12:06 AM

Hi Mike,

Can you give us an update on the status? Is this idea on the roadmap somewhere?
Especially with report extensions this will become even more important.

Greetings,
Steven

Category: Reports and Business Intelligence

RE: Report Inspector

Stefan Lippeck on 2/15/2021 9:34:18 AM

It's been 2 Years now and this essential Development Tool is still missing. - Can you at least give us the Dataset back?

Category: Reports and Business Intelligence

RE: Report Inspector

Vit Coufal on 12/3/2020 8:13:15 AM

Report Inspector is really important to have.
It would reduce the time designing reaport dramatically, there would make Business Cenzral more competitive to other ERP Products.
Please implenet asap.

Category: Reports and Business Intelligence

RE: Report Inspector

Manfred Brandstetter on 8/26/2020 5:02:51 AM

For the development of complex reports it is essential to be able to analyze the data.
Please do not put it into the "long term roadmap", we need it as soon as possible.

Category: Reports and Business Intelligence

RE: Report Inspector

Steven Renders on 7/7/2020 11:23:32 AM

Fyi, this can serve as a workaround:
https://thinkaboutit.be/2020/06/how-do-i-create-a-mini-report-inspector/

Category: Reports and Business Intelligence

RE: Report Inspector

Matthias Rabus on 6/28/2020 7:21:13 AM

That's one of the biggest misses in BC16 right now. Please add the report inspector asap

Category: Reports and Business Intelligence

RE: Report Inspector

Pedro Quintas on 6/24/2020 10:44:31 AM

Please provide this ASAP.
It is essential for developers.

Category: Reports and Business Intelligence

RE: Report Inspector

Christine Rauwolf on 6/24/2020 10:08:25 AM

It is also used in the analysis of permissions or correction. You need to be able to quickly determine the ID of an object (report).
We need this again really quickly!

Category: Reports and Business Intelligence