Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multiple Reports in a Single Worksheet using a Excel Template
 Login/Join
 
Silver 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: 47 | Location: BOWL OF PASTA | Registered: October 13, 2016Reply With QuoteReport 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: 923 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.