How to Customize Excel Sheet Names in Bold Reports

Bold Reports offers the ability to customize the names of Excel sheets instead of using the default name “Sheet1”. This customization feature enhances readability and allows users to provide more descriptive and meaningful names for the sheets in the Excel export.

Customize the name of an Excel sheet for the entire Tablix

1. Select the Tablix for which you want to customize the name.

   

2. In the Miscellaneous section, enter the desired name in the “Page Name” field.

   

3. Run the report and export it to excel. Please find the difference in the following picture.

   

Customize the name of an Excel sheet for Each group in Tablix

1. Select the Tablix group which you want to customize the name.

   

2. In the Miscellaneous section, enter the Page Name.

   

   In the Page Name, the group field name is used, which dynamically changes for each group.

3. In the Page Break section, change the Break Location to Between.

   

4. Run the report and export it to excel. Please find the difference in the following picture.

   

Please find the sample reports below,