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     Multiple file output from one hold in report caster [Closed-Not Solved]
Go
New
Search
Notify
Tools
Reply
  
Multiple file output from one hold in report caster [Closed-Not Solved]
 Login/Join
 
Gold member
posted
Hello all,
wondering if it's possible to create two deparate file outputs of different formats from the same hold file (flat) in the same fex using report caster. That is:
I'd like to create a summary Excel file from my file M1194WF then create a detail TAB file from M1194WF. Is there a way I can do this in Report Caster sending either via email or to Report Library? Do I need to use FILEDEF or WRITE or something?

thanks
Bob V

This message has been edited. Last edited by: BobV,


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 92 | Registered: February 20, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi B,

You will need 2 fex; where each will generate one output format.
Then in your schedule, add one task that will call each fex and assign the proper output format to the task.

This work for e-mailing distribution.


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: 2234 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks for the response Martin. I was trying to avoid that because then (I think) I would have to run the entire procedure twice spinning through the source tables that create the final hold file I need.

Bob


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 92 | Registered: February 20, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You can add another step (step 0 ) where you create your hold file and hold it somewhere in a app for then have your reports reading that app.

fexhold_step-0:

APP HOLD X
END
TABLE FILE CAR
PRINT SEATS
DEALER_COST
BY COUNTRY
ON TABLE HOLD AS TMP FORMAT FOCUS
END
APP HOLD
END

fexrpt1_step-1:

APP PREPENDPATH X
END
TABLE FILE TMP
SUM DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
END

fexrpt2_step-2:

APP PREPENDPATH X
END
TABLE FILE TMP
SUM SEATS
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
END

Then have a schedule calling step-0, step-1 and step-2. Something like that should work.

This message has been edited. Last edited by: MartinY,


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: 2234 | 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     Multiple file output from one hold in report caster [Closed-Not Solved]

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