Hi Gilson
Here is how I prefer to do it:
Depending on the type of report that is built, I often build the report in the area with the system formulas for figures.
This way you can use the option to hide empty rows and columns when running the report.
Just be sure to insert a few rows (maybe 20) above the data rows so you have enough space to build a heading that will not be overwritten when the layout is updated. (Make sure to always to say ok to update the layout when new accounts are added in the row definition!)
I also insert a column before the figures to add the account names. You can also insert extra rows and columns in the data area without problem.
This way the maintenance of the report is a lot easier, because new rows are inserted on the right place in the report, you just have to make sure that they have the right layout and that they appear on the right side of any additional rows you have added.
With the same logic, if you build your own summations rows instead of using the data, you want to build it outside of the data area. I prefer to use the same sheet as it makes it easier to see where the data is coming from, but you can also use additional sheets. And of course if the report should contain of several sheets, you build the report that way. This way you use the data only as a base, and can build a report with a totally different layout of figures. For these kind of reports I prefer to work with an Index formula to get the data to the report sheets.
Tip: I export the structure for each report separately to be able to restore them easily in case they would crash and the layout be destroyed (sometimes happening when making changes in the row definition). At least export before starting changing a report. Saves a lot of time!
Kind regards
Kerstin
------------------------------
Kerstin Kernwein
------------------------------
Original Message:
Sent: Tue August 25, 2020 10:47 AM
From: Gilson de Barros
Subject: Reports on Report Generator
Hi all, hope everyone is doing well.
I am doing some experiments here and would be very happy to know how are you guys building your Report Generator reports.
Do you build them on the "Database" sheet? If so, do you build them besides the "System Reserved Area" or in the midlle of it?
Formatting or puting some formulas on this area is a bit risky when you have to add elements on dimensions, that's why I believe the best practice is to do this on a beside sheet.
Thanks in advance for the responses.
My best regards.
------------------------------
Gilson Lins de Barros
------------------------------
#CognosController