Allow the Excel Sheet Names to be Set With Expression When SplitWorksheetOnPageBreak is True
Currently, when you set SplitWorksheetOnPageBreak to True, the Excel Sheet name is formed from the DocumentName or ReportName and the number of the page.
It would be very helpful if the report authors can manipulate these names with Expressions.
9 comments
ADMIN
Todor
Posted on:5 Mar 2025 09:29
Hi Kev,
Our developers and managers will discuss the exact feature and its implementation and hopefully plan it for one of the upcoming releases.
I would love for this to be an expression bound to the group where the page break exists, which could be an expression related to the data context. In our existing SSRS reports, we have a billing report that breaks on the Customer and each Excel worksheet is the Customer's name, this makes it human-readable. This is navigated using a bookmark on a summary page, which lists all of the customers.
It's good to know that this is in the pipeline.
Martin
ADMIN
Dimitar
Posted on:23 May 2024 07:54
Hello Martin,
We couldn't include this feature in the Q2 2024 release but it is part of our plans for the near future. The item will be updated as soon as we have officially planned a release date for it and you will be notified of the update automatically.
In the meantime, we would like to gather more information for how our users may want to use such functionlity. For example, would a field from the report data context be used in the expression, a report parameter, an user function or even a simple expression that concatenates two strings?
We appreciate any feedback you may have on how you would like to make use of the functionality.
I've been working with SSRS for many years and am now transitioning to Telerik Reporting, this is a must for anyone creating customer-facing reports. To have worksheets split on a page break is great, but not having any control over how those worksheets are named makes the reports look amateur.
Can we get confirmation that this feature is on the roadmap? Looking at those recently completed feature requests, they have far fewer votes than this one, so no reason why this shouldn't be bumped up the queue.
ADMIN
Todor
Posted on:22 Nov 2023 11:50
Hello Tommy,
We will do our best to release this feature with R2 2024 scheduled for June 2024.
As a voter, you will be automatically updated when its status gets modified.