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] Combine multiple reports into one excel report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Combine multiple reports into one excel report
 Login/Join
 
Silver Member
posted
Hello,

I have multiple webfocus reports that need to be consolidated into one excel file. Essentially each tab of excel workbook would represent each individual excel report.

How can this be done? Appreciate if someone can guide me with this.

Thank you,
Gagan

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


WebFOCUS 8
Windows, All Outputs
 
Posts: 29 | Registered: September 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The answer/technic may differ according to answers to below questions :

1- Are they from the same fex/execution ?
2- Are they using all the same TABLE FILE...END result ? Meaning, are they all using the same data source or each have their own ?
3- Do they have the same output layout or each have its own list of displayed column ? (Rpt 1 = col A, B & C, Rpt 2 = col A, B, C, D & E, …)
4- How the reports are produced ? Direct execution, from Report Caster, … ?

and maybe other questions that I don't think of actually


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2394 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
 
Posts: 45 | Registered: October 07, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Check the documentation like Mike has posted.

Also what version are you on, there are many versions of 8.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 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] Combine multiple reports into one excel report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.