377

Report Inspector

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 ...

Read more...

22 Comments

Read more... 22 Comments

Category: Reports and Business Intelligence (231)

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 
221

Enable incremental refresh for Business Central in Power BI

Currently the Business Central connectors in Power BI, and Power Query, do not support incremental refresh: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#configure-incrementa...

Read more...

11 Comments

Read more... 11 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team
211

Direct printing

One of the biggest lack on D365BC SaaS is the direct printing functionality. On scenarios like warehouse and production having the possibility to direct print a report to a local printer is a must to have. Why not creating a functionality for that? It could be possible to handle this scenario wit...

Read more...

14 Comments

Read more... 14 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Completed
Ideas Administrator
Good news! We released this feature as part of the functionality in Enable non-interactive printing in the cloud.
Please refer to the following link for more information:
 
Best regards,
Blazej Kotelko
Program Manager, Microsoft

190

Option to merge multiple pdf files into one document

Our users want to batch print Sales Invoices. In WinClient we could solve that, but now when running WebClient only (SaaS) we're having different troubles. Since we need to use the configured Custom Report Layouts, we have to print the invoices one a time. If we call Report.Run one at a time, th...

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 
 
Your help is greatly appreciated, 
Microsoft  

133

Batch printing with different Custom Report Layouts

When printing reports that have a custom report layout that is configured per record (e.g. different custom "Sales Invoice" report layouts per Customer) the report must be printed per record (eg. per "Sales Invoice Header" record). Otherwise the custom report layout will be ignored. The users ...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Business Central Team

128

Allow users to change sort order of reports

When running a report there is no ability to change the report sorting order. This function was available in the Windows Client reports. For instance: when running the Aged Accounts Receivable report you could change the sorting to be Search Name rather No. which is more useful if using standar...

Read more...

4 Comments

Read more... 4 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. We are considering adding it to our longer term roadmap. 

 

Your help is greatly appreciated, 

Mike Borg Cardona 

Product Manager, Microsoft 

102

Add Business Central as a Data Source in DataFlows

Currently it is not possible to connect a DataFlow directly to Business Central, like it is in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-define-new-entities https://docs.microsoft.com/en-us/power-bi/connect-dat...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Planned
2022 Release Wave 2
Ideas Administrator
Thank you for this suggestion! We are working with Power BI team to enable this very soon (not related to the Business Central version).

Microsoft
94

Include "Data Export Services" to BC Cloud

Copy the Data export Services function from Dynamics 365 to BC Cloud Hi I will strongly recommend the BC Develoment team to take a look at the dynamics 365 Platform regarding the product Data Export Services, and include this as a technology to export data from BC. Not only for reporting purpose...

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your suggestion, this functionality is currently not on our roadmap. We will keep tracking it however, to consider for our future releases.

Kind regards,
Business Central team 
85

Allow users to add filter fields on report option

When running a report, a user can choose a filter for the pre-defined fields or replace an existing filter field with a new one, but a user can't add additional filter fields. For example, the Inventory Valuation report offers three field to filter on. Let's say the user makes use of these thr...

Read more...

6 Comments

Read more... 6 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in Business Central 2019 release wave 2. Please refer to the following link for more information: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/powerful-filtering-capabilities-reports Your help was greatly appreciated, Mike Borg Cardona Program Manager, Microsoft
82

Equal naming of reports being emailed/saved as PDF

This affects all documents, but in this case I'll use Reminder as an example. When issuing a reminder and choosing email-distribution for the file, it's created as an attachment to the email with the name "Sales Issued Reminder XXXX.pdf". If I chose to print that same invoice and/or save it to ...

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Business Central Team