I wrote a repot that I will be posting on my dashboard and I want to caster a job for this report also. This report has parameter that needs to be passed in parameters.
Following is the issue:
This report should run in report caster with HIGHEST 1 DATE, so I have a BY field HIGHEST 1 DATE but when user runs it from the dashboard as live report user see a parameter screen and pass date in the parameter. At the moment i have to maintain two FEX files one for the caster and one for live report. Is there a way I can have WHERE condidion with HIGHEST 1 DATE in the report caster so i dont have to maintain two seperate procedures one for live and other for the report caster?
ArifThis message has been edited. Last edited by: Kerry,
Yeah, Just set a variable that tell the procedure whether or not it is being run through RC and then brach accordingly when it is. Use -DEFAULTH &var='N' in the procedure but set &var to 'Y' in the RC task (Advanced button)
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
Thanks for the tip but I think I still dont know how would I say
IF &CAST EQ Y THEN SORT IT BY HIGHEST 1 DATE ELSE SORT it by user defined date? Can you give me an example? Following is my procedure:
TABLE FILE TEST SUM Field1 Field2 BY HIGHEST 1 DATE END FOR LIVE REPORT TABLE FILE TEST SUM Field1 Field2 BY DATE WHERE DATE EQ '&DATE.(FIND TEST.DATE,TEST.FYPW IN TEST).DATE.'; END
How do I make it one procedure?
There are many solutions to this although one I use is something like this -
-SET &Cmt1 = IF &DSTJOBID.EXISTS THEN '' ELSE '-*'; -SET &Cmt2 = IF NOT &DSTJOBID.EXISTS THEN '' ELSE '-*'; TABLE FILE TEST SUM Field1 Field2 &Cmt1.EVAL BY HIGHEST 1 DATE &Cmt2.EVAL WHERE DATE EQ '&DATE.(FIND TEST.DATE,TEST.FYPW IN TEST).DATE.'; END
|Powered by Social Strata|