In the "Rendering" section of a report, for Layouts where the property "Type" is "Excel", it would be great to have a property to indicate that the data is to be loaded to the Data Model instead of a Table.
Reason: excel "Tables" are limited to 1,048,576 rows, but the Data Model allows for 2 billion records to be loaded.
Loading the data directly to excel's data model would therefore allow us to overcome this limitation.
Example:
...
rendering
{
layout(ExcelLayout01)
{
Type = Excel;
LayoutFile = 'ExcelLayout01.xlsx';
LoadDataTo = DataModel;
}
}
...
Comments
For clients who need to analyze monthly data, for months where more than 1.1 million records were generated, the Excel Layout would not work. Having this option would make business central reports virtually limitless.
Category: Reports and Business Intelligence