Focal Point Banner


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 myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple Reports in a Single Worksheet using a Excel Template

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Multiple Reports in a Single Worksheet using a Excel Template
 Login/Join
 
Gold member
posted
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
 
Posts: 52 | Location: BOWL OF PASTA | Registered: October 13, 2016Report This Post
Master
posted Hide Post
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, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple Reports in a Single Worksheet using a Excel Template

Copyright © 1996-2020 Information Builders