Enable using Query objects as Data Items in Report (Page and XMLPort) Objects
Making it possible to use (reference) query objects in a data item, instead of only tables, makes it possible to create better, faster and reusable datasets. Currently to be able to use Query objects as data items in reports that has to be done using AL coding, which is cumbersome and inefficien...
Make it possible to reuse translation files in cloned base reports
When a report extension is not possible and you need to clone a base report, obtaining or reusing the translations from the base report in the cloned report is extremely cumbersome and time consuming: https://navinsights.net/2020/11/17/how-to-translate-copied-reports/ Having a way, in VSCode, to...
Power BI Embedding: Make it possible to add a Company filter or SystemId in the link (filter).
To make sure when you embedd a Power BI report in a list page in Business Central, you need to add a filter for the Pk of the table, so the record in the list page is linked to the same record in the Power BI report. However, the Power BI report may contain data from another, or multiple, compan...
Expose Report Datasets as (read only) APIs?
Making it possible to expose the dataset of a report as a read-only api, for example with DataAccessIntent =ReadOnly by default, would be interesting for reporting/BI solutions like Power BI, dataflows and others.
Reports (data items) have similar functionality to query object...
Create and update APIs to get the pdf of a report in Power Automate
There are some APIS that support it, https://thinkaboutit.be/2023/03/how-do-i-get-business-central-pdf-documents-in-power-automate but many APIs that do not support it.
Currently you can only use it on:
- salesInvoice
- salesQuote
- salesCreditMemo