Part 1 – Designing the dataset

The dataset is designed within the report by specifying the data item field's columns and their properties. They have a big influence from a qualitative perspective (in which format is data exported?) and from a quantitative perspective (how many rows are processed?). Both have a clear impact on report performance.

A short example is represented by decimal data types. When specifying a decimal data type in a dataset, two fields are always included: the decimal data and its formatting. This means that, together with the decimal field, you always have a repeated text variable tightly bound to it. This would increase the dimension of the dataset and, consequently, influence report performance.

What could be the ...

Get Mastering Microsoft Dynamics 365 Business Central now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.