Implement a SQLJoinType property in Report objects


Currently the only way to implement an inner join or a left outer join between data items is using the PrintOnlyIfDetail property. In Query objects there's a SQLJoinType property. Why not also implement the SQLJoinType in reports, instead of the PrintOnlyIfDetail property? Better control over ...

Read more...
1 Comments

Read more...
1 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Reports and Business Intelligence (231)

STATUS DETAILS
Needs Votes