Plaza 365
Plaza 365

No results found for your search

RegisterLog in

11

Dynamics 365 Business Central: How to use a query to create a report dataset (Creating Report with Query)

Visit article

#create

#dataset

#query

#report

Dynamics 365 Business Central

Category

Dec 9, 2024

Published date

Text

Article Type

AI Summary

  • Business Central query objects enable the retrieval of records from tables and combining them into rows and columns in a dataset.
  • Query objects can be used to create reports by following a fixed pattern that involves adding a global variable pointing to the query object and using triggers for data item definition.
  • Reports can be tested by exporting results as raw data to a Microsoft Excel file to validate expected data and match layout controls with dataset value types.
  • A simple layout can be created for the report by following the provided source code on Github.
  • The article also mentions additional features such as API query type, tooltips on query columns, support for SaveAsJson, in-client analysis mode in queries, and the QueryCategory property.
  • Business Central 2024 wave 2 introduces tooltips on query columns and support for SaveAsJson on the Query object.
  • Business Central 2023 wave 2 allows analysis, grouping, and pivoting of data on queries using multiple tabs in the in-client Analysis mode.
  • The QueryCategory property in Dynamics 365 Business Central enables the execution of queries from pages.

Registered users can view the full text for FREE!

Sign In Now!