Sheet Titles and New Sheets in Excel

[Jeff M.]

Hi All,

I was just wondering if it's possible to do 2 things:

1. Firstly throw a page break to ensure a new sheet is opened. I'm aware that I would have to have the length of each sheet long enough to ensure everything I want on one page will fit and that merge pages will have to be set to no.
2. Secondly, can the sheets be named somehow withing the Genero Report Writer? I assume I'll have to open the created sheet in background and rename these but thought I'd ask.

Thank you.

Jeff

[Alex G.]

Hi Jeff,

You are right on both topics.

I double checked regarding the sheet title and it will generate the text "Continued from sheet %d" or "Sheet %d" depending on whether it is a spillover (XLS format only) or a sheet for a page.
I am thinking that we could add a rendering hint that makes the Excel output take the page root name as sheet name.
We have a similar option for naming the images files in the case of image output. Would that help?

Best regards,

A. Geller

[Jeff M.]

Hi Alex,

I'm very sorry that I just saw the reply.

The problem with taking the page root name is that it would be the same for each page in a report wouldn't it?

I'm thinking along the lines of perhaps a new page per month of financial information, eg: April 2018, May 2018, June 2018.

[Alex G.]

Hi Jeff,
no worries about the late reply.

>The problem with taking the page root name is that it would be the same for each page in a report wouldn't it?

Yes and no. No, because a report can have any number of page roots so you could have different names for each one of them.
And yes because you can't set the name property with a RTL expression so that you could not have a dynamic amount of them.
If you could set the name as an expression, then you could place the page root in a trigger (e.g. one that repeats for every month to pick up on your example) and have a differently named page root per month.

There are two feature requests registered for this (GRE-520: "Define a name for the different sheets in an Excel report" and GRE-354: "Get a way to decide when to produce a new sheet when running an XLS/XLSX report").
I propose to add you to the list of requesters for these.
I am afraid that I have no better answer at the moment.

Best regards,

Alex