Share via

SSRS export to excel not setting tabname as expected

Christine Edwards 0 Reputation points
2023-02-20T19:16:32.5966667+00:00

I have a report grouped by department. I am trying to export to excel and change the spreadsheet tab name to the department name.

I have set the pagename = =Fields!Primary_Department.Value

group properties

When I run the report, if the result set for each department is short (up to 40 rows for the department) the export works and the spreadsheet names are changed as expected.

Correct

When I run the report, if the result set is longer (I use a department with a 60 row result set), the excel spreadsheet tab names get messed up.

Incorrect

I have looked everywhere to try and figure out what I can do to correct this and have not been able to get it to work. Any help would be greatly appreciated.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-21T01:54:18.65+00:00

    Hi @Christine Edwards

    I did a simple test, almost every group has a lot of data, but their names are displayed normally. 1

    Have you added a page break between each group?

    2

    Best regards,

    Aniya

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.