As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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
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,
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.
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006