[CLOSED] Put DateTime Stamp in ReportCaster Job Output file
Hi All,
Firstly, I want to thank to all for handing me the solution for my WebFOCUS Query.
I have one other question Related with ReportCaster jobs. How can I add time-stamp to output file name.
Example:- -* File MainFile.fex TABLE FILE CAR BY BURST_VALUE BY CAR.COMP.CAR BY CAR.CARREC.MODEL ON TABLE PCHOLD FORMAT HTML ON TABLE NOTOTAL ON TABLE SET CACHELINES 100 ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, HFREEZE=OFF, $ ENDSTYLE END
And When we will be scheduling the Job for above Report. We will receive file with MainFile.html name. But I need a ouptfile name like "MainReport_10_10_2014 7_07 PM.htm".
Please provide some solution for same.
Regards, Neelima GuptaThis message has been edited. Last edited by: <Kathryn Henning>,
Use the search option above to search on "report caster variable". This has been discussed many times and I think the answer is still "no, not within normal use".
However, the Forum members are a very clever lot and many suggestions have been ventured and may suit your current needs.
I would hazard a guess that this may be something that might be considered for a future release.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
October 11, 2014, 04:12 PM
Neelima
Thanks Tony for Respond on my post, I have researched and found some trick to Append current date and time with Report Caster file output name like to create a temporary field and use as first BY field with NOPRINT Statement (like Burst Field). and i got my desired result. But the same time, I need to achieve bursting functionality also. And currently I am struggling with this only. Is there any another way to do the same.
Thanks, NeelimaThis message has been edited. Last edited by: Neelima,
I have succesfully achieved this by using a dynamic distribution list, as in the dynamic list you can also determine at run-time what the first part of your file name will be, so no problem to include a datetime stamp. It also provides more flexibility in bursting as you do not need to keep your distribution list up-to-date in ReportCaster.
Martin.
WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
October 14, 2014, 05:10 AM
Neelima
Hi Martin,
Thanks for reply.. How can i check the first part of file name dynamic list. Please share code snippet for same.