377
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
Ideas 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

S

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

Category: Reports and Business Intelligence

S

Awesome!!!

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

A very big thank you! :-)

Category: Reports and Business Intelligence

S

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

S

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

S

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

S

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

S

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

S

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

Category: Reports and Business Intelligence

S

Please provide this ASAP.
It is essential for developers.

Category: Reports and Business Intelligence

S

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