Focal Point
[CLOSED] Multiple Reports in a Single Worksheet using a Excel Template

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9207096196

September 19, 2019, 10:04 AM
tomatosauce
[CLOSED] Multiple Reports in a Single Worksheet using a Excel Template
I am trying to achieve a report of the following compound structure but using a excel macro enabled template for us to make some styling changes. I know compound report commands wont work while using templates.

Report 1 OPEN NOBREAK

Report2 NOBREAK

Report3 NOBREAK

Report4 CLOSE

All the examples I saw in the forum so far only demonstrate multi tab reports using a template like using SHEETNUMBER1 and SHEETNUMBER2 but no examples with multiple reports in a single worksheet. I want to achieve this structure using a template.

sheet1
--------
report1
report2
report3
report4



Is there any way to achieve the above structure using a template ? Any help is much appreciated.

This message has been edited. Last edited by: FP Mod Chuck,


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
September 20, 2019, 08:23 AM
jgelona
Sure. Since you are using a macro, build the 4 reports on separate sheets. Then in your macro copy the cells from sheet 2 to where you want them in sheet 1. Do the same for sheets 3 & 4, then delete sheets 2, 3 and 4. Then apply your additional formatting.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.