[CLOSED] Report Run on First Saturday of the Month
Hi
In table every day the data is loading and load time stamp is field is updating time in table based on this load time stamp i need to retrive the data .
I have requirements like this
this report should include a full month( previous month data on it) should run the second Friday of the month,
please can any one help me how to do
Thanks This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
December 12, 2012, 10:21 AM
RSquared
Create a Report Caster schedule and select Month and then select 2nd Friday
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
December 12, 2012, 11:47 AM
Deepu
Hi we are not using Report Caster
if Report runs on "First Saturday of the every Month" (Reports Running manually) Reports need to show the data previous month to before This date First Saturday of the every Month"
In table every day the data is loading and load time stamp is field is updating time in table based on this load time stamp
Note:based on this load time stamp field in table i need to pull the data.
ThanksThis message has been edited. Last edited by: Deepu,
WebFOCUS 7.6 Windows, All Outputs
December 12, 2012, 12:01 PM
nd
Do you need help with a filter in the report? E.g. select items with a time stamp from the beginning of the previous month through the second friday of the defined month?
Or, ALL of last month (as indicated by load time stamp) becomes available as of the second Friday of the subsequent month?
You can then use these beginning and ending date variables to filter your data (example below). I am making the assumption that your load time stamp has a date-time format. Function HDATE will extract the date portion. If this is not the case, then another approach may be necessary to extract the dates from your load time stamps.
DEFINE FILE xxx
LOAD_DATE/YYMD = HDATE(load time stamp,'YYMD');
END
-*
TABLE FILE xxx
SUM/PRINT xxx
BY xxx
WHERE (LOAD_DATE FROM '&RPT_MTH_BEG' TO '&RPT_MTH_END');
END
WebFOCUS 7.7.05
December 13, 2012, 03:11 AM
Ahamed Thaha
If you are not using Report Caster, you need to write a batch program (Report.cmd) similar to below to call a t3i(Call_fex.t3i) file:
The below fex will call the generate_report.fex only on first Saturday of every month and your logic to fetch data should be in the include fex (generate_report.fex)