Unplanned
Last Updated: 30 May 2024 06:39 by ADMIN
Pierre
Created on: 29 Jun 2022 13:46
Type: Feature Request
17
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.

7 comments
ADMIN
Todor
Posted on: 30 May 2024 06:39

Hello Martin,

Thank you for sharing your scenario and suggestions with us. We will consider them when implementing the feature.

We agree that an Expression would be the best option for setting the Worksheet names dynamically and we will probably work in this direction.

Regards,
Todor
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Martin
Posted on: 23 May 2024 08:34

Hi Dimitar

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.

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Martin
Posted on: 16 May 2024 08:17

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.

Regards,
Todor
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Tommy
Posted on: 16 Nov 2023 01:03
Wow, yet another simple feature that is missing when compared with SSRS?
Any update on this?
Jeff
Posted on: 11 Oct 2023 12:37
Thank you. This is probably going to be a show-stopper on some of my client projects.