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] Put DateTime Stamp in ReportCaster Job Output file
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Put DateTime Stamp in ReportCaster Job Output file
 Login/Join
 
Platinum Member
posted
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 Gupta

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 182 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
Neelima,

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.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5637 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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,
Neelima

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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 182 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Master
posted Hide Post
Hi,

You should use Wildcard Characters in burst value in the distribution list.

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi 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 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Martin,

Thanks for reply.. How can i check the first part of file name dynamic list. Please share code snippet for same.

Thanks and Regards,
Neelima Gupta


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 182 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Master
posted Hide Post
You need to use wildcard search for burst value.

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Put DateTime Stamp in ReportCaster Job Output file

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