Daily report generation
Sir I need to generate report for daily once at 6.0 am can u please tell me the settings regarding Retrival type, start time as well as settings regarding scheduling definition which means what should be my scheduling window time begins and run every??
Please give me the solution sir......waiting for your warm reply...
Thank you
Please give me the solution sir......waiting for your warm reply...
Thank you
Asked 4 months ago
Answers
1
HI,
Please use the following formulas to call back the values from the logs using data direct to create a report.
Report End time: =C5-TIMEVALUE("12:00:00") where C5 is the cell reference for reference time
Report Start Time: =DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())-IF(HOUR(C2)>=16,1,0))+TIME(HOUR(C2
),MINUTE(C2),SECOND(C2)) where C2 is the cell reference for reference time, which in your case is 6AM.
In scheduling definition, use a periodic schedule running at 24 hours. since report should generate at 6AM to 6AM, let the report be generated at 6.05.
Please use the following formulas to call back the values from the logs using data direct to create a report.
Report End time: =C5-TIMEVALUE("12:00:00") where C5 is the cell reference for reference time
Report Start Time: =DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())-IF(HOUR(C2)>=16,1,0))+TIME(HOUR(C2
),MINUTE(C2),SECOND(C2)) where C2 is the cell reference for reference time, which in your case is 6AM.
In scheduling definition, use a periodic schedule running at 24 hours. since report should generate at 6AM to 6AM, let the report be generated at 6.05.
Answered 4 months ago
Add new comment