Back to Four Js Website
Four Js Customer Forum
Subscribe for automatic updates:
RSS
Sign in for full access
|
Help
Four Js Development Tools Forum
>
Discussions by product
>
Reporting tools (GRW, GRE)
>
Sheet Titles and New Sheets in Excel
Most recent posts
Pages: [
1
]
« previous
next »
Reply
|
Print
Author
Topic: Sheet Titles and New Sheets in Excel (Read 12261 times)
Jeff M.
Posts: 40
Sheet Titles and New Sheets in Excel
«
on:
October 15, 2018, 10:42:50 am »
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.
Posts: 149
Re: Sheet Titles and New Sheets in Excel
«
Reply #1 on:
October 15, 2018, 11:11:13 am »
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.
Posts: 40
Re: Sheet Titles and New Sheets in Excel
«
Reply #2 on:
January 18, 2019, 11:30:26 am »
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.
Posts: 149
Re: Sheet Titles and New Sheets in Excel
«
Reply #3 on:
January 18, 2019, 04:32:47 pm »
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
«
Last Edit: January 21, 2019, 09:45:15 am
»
Pages: [
1
]
Reply
|
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General
-----------------------------
=> General Discussion
=> Ask Reuben
=> WWDC21
-----------------------------
Discussions by product
-----------------------------
=> Products announcements
=> Genero BDL
=> GWS
=> GAS and GBC
=> GDC
=> Genero Mobile for Android or iOS
=> Genero Studio
=> Reporting tools (GRW, GRE)
-----------------------------
Jobs
-----------------------------
=> Jobs
Powered by SMF 1.1.21
|
SMF © 2015, Simple Machines
Loading...