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 One Output
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multiple Reports in One Output
 Login/Join
 
Silver Member
posted
This is a strange requirement. We have a Webfocus 8104 application that pulls from Microsoft SQL Server.

On the server we have a master table that gets loaded by informatica. Files come into informatica through a network drive as pipe delimited files and are loaded. There are groups of reports based on the set of files.

To run the reports the user logs into the portal and selects a client from a dropdown. That looks at the database and pulls all of the rounds of data that client has along with the reports and different timestamps if there are any.They select excel or html which looks at a stub procedure that has either a ahtml fex or excel fex. Then it runs the report.

The issue we're trying to solve is if a user selects a client and a round of data to export all of the fex files as a single excel file. So in essence looking at the client and road and then outputting all of xlsx fexs in one report.

Has anyone done something like this, I know its odd but wanting to check. If not what suggestions would you have to making this work.

I've thought about caster but wasn't sure. Also thought of dynamically populating a list box with of the available reports and then a button to run them.

Thank you for any help in advance

Warren

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


8.1.0.4
Windows 7
Excel, AHTML, HTML,PDF
 
Posts: 39 | Location: North Carolina | Registered: September 14, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
All fex write extracted data into one common data file with specific id then :
- use Excel BYTOC feature based on the id
- use OPEN and CLOSE feature using data id
- use an Excel template where each data id will reference its own Excel sheet (SHEETNUMBER x)

All fex write its own data file then another fex read those files to produce the final report with any of above options

And many more options combining different technic


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2189 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply 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 One Output

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