Search code examples
excelreporting-servicesssrs-2016

SSRS How to change export Excel Tab Name (2) when ther is no group name

I am using "Break to new page" for every Group value in my report. And I set the TAB names of the excel export to be the Group-Value itself. This works fine for the data within a group. But on the last TAB there is the overall "TOTAL" which is in no group.

So excel just takes the last groupname it finds and addes a "(2)" at the end of the TAB-name. enter image description here

I tried to set a fixed name for ISNOTHING() or IIF(Value=""...) but it did not work.

Does anyone have an idea? Please let me know and thak you in advance!

Here is the data:

CREATE TABLE [dbo].[PerPage](
    [VendorDim] [nchar](10) NULL,
    [Amount] [int] NULL,
    [SomeText] [nchar](10) NULL
) ON [PRIMARY]

INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('AR', 1, 'a')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('AR', 2, 's')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('BR', 3, 'f')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('BR', 4, 'g')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('AH', 5, 'h')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('AH', 6, 'j')
INSERT [dbo].[PerPage] ([VendorDim], [Amount], [SomeText]) VALUES ('AH', 7, 'k')

Here is how the Report is built: enter image description here

When exporting to excel for every Tab it take the name of the Group VendorDIM. But the Total is not in any group.

Solution

  • I will remove the total from the grouped Tablix.
    Add a new Tablix page with the summed up Totals.
    And give it a "Total" Name.