Problem Description
The current XLSX export functionality offers only two options for naming worksheets:
-
{ItemName}(the report item name) -
{PageNumber}(the sequential page number)
These options are very limited and do not provide sufficient flexibility for dynamic, data‑driven worksheet naming.
Users need to generate Excel workbooks where worksheet names reflect actual report data (e.g., customer name, contract ID, or group labels).
The current system does not allow inserting data fields or expressions into worksheet names. This significantly restricts reporting capabilities, especially when creating multi-worksheet reports grouped by business entities.
Requested Enhancements
It is essential that these features are also supported on the report server.
1 Support for Data Fields in Worksheet Naming
The system should allow configuring worksheet names using fields from the dataset or report parameters.
Example:
Xlsx.WorksheetName = {Left(Kundenname, 31)}
(condition to ensure the Excel limit of 31 characters is respected)
2 Support for Formulas / Expressions
Worksheet names should be able to use expressions to compose text dynamically.
Examples:
-
Concatenate fields
-
Apply text functions such as
Left(),Trim(),Replace() -
Combine constants with data values
Example:
Xlsx.WorksheetName = {Kunde} + " - " + {Vertragsnummer}
3 Support for Group-Based Worksheet Naming
Worksheet names should inherit or be derived from:
-
The group header label
-
The grouping field value
-
A custom expression defined at the group level
Example:
Use the first grouping level as worksheet name:
Xlsx.WorksheetName = {Group1.Label}
4 Option to Auto‑Generate Worksheet Names Based on a Table of Contents
Introduce an option to generate worksheet names using a report-level table of contents (TOC).
Examples:
-
“Use TOC Level 1 for worksheet names”
-
“Use TOC Level 2 indentation structure to generate sheet names”
This would enable logically structured workbooks where worksheet names correspond directly to report navigation elements.
Benefits
-
More meaningful worksheet names
-
Improved usability in multi‑sheet Excel exports
-
Better alignment with business needs (e.g., customer‑specific sheets)
-
Reduces manual post-processing
-
Enables clear, structured workbooks for reporting packages