Improvement
Report Generator – Added a new option for Excel to display data from A1 with no Metadata, i.e., report header, filters summary and number of results.
The option can be used for ad-hoc reports and for scheduled reports via Task scheduler.
Notes
Supported environments:
.Net
Version
5.25.1
Instructions
Sbo upgrade.
Examples
Display Metadata
Excel layout including Metadata such as Report header, filters summary and number of results .
Display Data from A1 Column
Excel layout not including Metadata such as Report header, filters summary and number of results.
Select report
Press “Settings” to apply the new option
Xlsx File Settings
Display Data from A1 Column = Yes
When enabled, the system displays the Excel spreadsheet from A1.
The metadata is not displayed.
Totals without breaks
When totals without breaks is enabled, the totals header lines (Sum/Min/Max/Avg/Count) are relocated in the last column.
Totals without breaks (XLSX Only) = Yes
Scheduled Reports
Excel layout not including Metadata such as Report header, filters summary and number of results.
Select report
Press “Scheduler” to apply the new option
Xlsx File Settings
Display Data from A1 Column = Yes
