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!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.