Hello everyone,

Thanks for all your patience and kindness to read my message. I am pretty new for Webfocus and i really need your helps. My company is using Webfocus 8 for some reports and I need to set up a schedule task in order to run those reports automatially.

There is one report that I need to input date and file name manually every month in order to run and retrieve the right data for reports.

source code :

DEFINE FILE EMPLOYEE_PAYROLL_MASTER
ALLZERO/A1=
IF ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.MINUTES EQ 0)
AND ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.DOLLARS EQ 0)
AND ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.UNITS EQ 0)
AND ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.CURRENT_EARNINGS EQ 0)
THEN '0' ELSE '1';
END
-PROMPT 'MDH'
-*Other
-* Report Painter generated APP HOLD command
APP HOLD ehr
-*End Other
TABLE FILE EMPLOYEE_PAYROLL_MASTER
SUM
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.MINUTES
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.HOURSX
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.HOURS
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.DOLLARS
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.UNITS
EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.CURRENT_EARNINGS
....
....
BY EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.APPT_DEPT_SH_NM
....
....
BY EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.EMPL_LAST_NM
....
....
....
....
WHERE ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.GTN_PPRD_END_DT EQ '>N_PPRD_END_DT' ) AND ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.REC_TYPE EQ 'EARNINGS' ) AND ( EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.ALLZERO EQ '1' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS &XFOCNAME FORMAT XFOCUS INDEX 'EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.GTN_PPRD_END_DT' 'EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.EVENTANDDESC' 'EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.DEPTANDDESC' 'EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.TITLEANDDESC' 'EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_PAYROLL_MASTER.EMPLOYEE_ID'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


thank you veyr much for your replies.

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

Let's first of all strip this GUI-developed code down to the essentials so it can actually be understood:

quote:

TABLE FILE EMPLOYEE_PAYROLL_MASTER
SUM
MINUTES
HOURSX
HOURS
DOLLARS
UNITS
CURRENT_EARNINGS
....
....
BY APPT_DEPT_SH_NM
....
....
BY EMPL_LAST_NM
....
....
....
....
WHERE ( GTN_PPRD_END_DT EQ '>N_PPRD_END_DT' ) AND ( REC_TYPE EQ 'EARNINGS' ) AND ( ALLZERO EQ '1' );

ON TABLE HOLD AS &XFOCNAME FORMAT XFOCUS INDEX GTN_PPRD_END_DT EVENTANDDESC DEPTANDDESC TITLEANDDESC EMPLOYEE_ID
END

Having done that, I don't see anywhere in your code where there is a prompt for the date. What date are you interested in for starters? There are many system-generated dates you can call upon and use in date calculations.

For your &XFOCNAME parameter, can you provide some samples of what you want it to look like, and explain how it varies?

hello George,

Thanks for your reply.

We run this report twice every month. Therefore, every time we will need to put MM/DD/YYYY accordingly. Is that ok for me to shedule the run?

thank you.

You can use &DATE parameter to get the system date and format it accordingly to use it in your report. Please let me know if you are looking for something else.

Thanks,
Pravin Singh

I'm still not at all clear why you want to input the run date. You are asking for a scheduled task, which implies using ReportCaster. With ReportCaster you can schedule a report to run as many times as you like in the month, or hourly, daily, weekly - whatever.

You mention that you are new to WF and perhaps rather than diving straight in it would be useful for you to obtain some training.