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     [SOLVED] Populating System date in the subject for ReportCaster jobs
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Populating System date in the subject for ReportCaster jobs
 Login/Join
 
Member
posted
Hi All,

I`m using &DATE in the subject line of the report caster job to display the system date for the report when it got distributed, all is fine as we expected until few days back, all of sudden report caster is delivering &DATE instead of system date, wondering what this should be, Any help is appreciated.
Thanks,
Teju

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


WebFocus 8204,Windows, Excel, PDF, HTML
 
Posts: 4 | Registered: June 25, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I just tested this and it works for me. What's changed in your environment? If you run this code do you see the value of &DATE?
  
TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE SUBHEAD
"&DATE"
ON TABLE PCHOLD FORMAT HTML
END


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
Hi Babak,

Thank you for your feed back,

I have an issue with report caster subject not in the report, I have &DATA In the place of the subject in the distributions , so when report get distributed, subject in the email will display the system date.

Thanks,
Teju


WebFocus 8204,Windows, Excel, PDF, HTML
 
Posts: 4 | Registered: June 25, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I understand. I tested &DATE in the subject of a report caster job and it works. As a test I suggested you see if &DATE has a value in a report. It's a diagnostic means to an end.

Another test might be to see if &YYMD in the subject line gives you a value. All of these will narrow down the problem and give you information that could help you figure out what's wrong.


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
I have &DATA In the place of the subject in the distributions


Unless this was a typo, &DATA is not a valid date parameter.


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 387 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Member
posted Hide Post
HI Babak,
It was worked for me also till few days back, we did not change any setting at the report caster, we added 50 more jobs &DATE in the subject, that all we did and from the day we added all the jobs we are getting this issue.

Hallway, it was my typo here but not in the scheduler.

Any suggestions?

Thanks,
Teju


WebFocus 8204,Windows, Excel, PDF, HTML
 
Posts: 4 | Registered: June 25, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Did you try &YYMD instead to see if that works?


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
Yes tried &YYMD, result is same just printing &YYMD in the email subject.


WebFocus 8204,Windows, Excel, PDF, HTML
 
Posts: 4 | Registered: June 25, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Does &DATE or &YYMD give you a value when you use it in a TABLE request as I'd suggested earlier?

If nothing has changed either in your OS or WebFOCUS and the only difference is that you've added 50 more jobs, the only other suggestion I have is for you to create a test job with the &DATE in the subject for 1 (one) report to be distributed. If that works, then somehow the number of tasks is causing an internal variable to get blanked out. Either way, I'm out of ideas. Have you opened a case with IB Tech Support? Please post here what you discover when you find a solution.


WebFOCUS 8204, Unix, Windows
 
Posts: 1617 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Just tried this on an 8.2.04 VM and it didn't give the date, only &YYMD or &DATE. Client Build/GEN: 48, Server (8.2.03M) GEN 1335.

However, on 8.1.05, 8.2.05 and 8.2.06 this is working fine.

I would suggest that you raise a case with tech support.

T

This message has been edited. Last edited by: Tony A,



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: 5577 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
I created some global variable at the system / environment level that can be used in the subject lines or as part of the output filename.
     &&YESTERDAY : 20190423            - This can be added to a subject line or filename.
     &&TODAYSDATE: 20190424            - This can be added to a subject line or filename.
     &&TODAYSMDYY: 04/24/2019          - This can be added to a subject line, not for a filename.
     &&TIMESTAMP : 05_07_2019_13_00_01 - This can be added to a subject line or filename.
     &&ENVIRNNMENT is hard-coded for the environment in which it resides.
The dates shown are, obviously, taken from the systems date variables.

Have fun with them. ~ Doug
 
Posts: 2967 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Populating System date in the subject for ReportCaster jobs

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