How to identify the last run date of the report every time That means last run date of the reports every time ). reports is running ManuallyThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
December 13, 2012, 03:23 AM
Ahamed Thaha
Do you have any userlog database which keep tracks/inserts a record each time any report or query is executed. Then it is easy to get the last run date details from that database.
7.7.03
December 13, 2012, 07:49 AM
George Patton
Why not just write the report name and date out to a file? And then create another report to read that file to give you the results?
My requirements like this i need to show the data Between this condition i,e where condition Note : LD_DATE is field that i what to filter is on this below condition.
where LD_DATE >=&Last_Run_Date and LD_DATE<=First_Saturday_of_the_MonthThis message has been edited. Last edited by: Deepu,
WebFOCUS 7.6 Windows, All Outputs
December 13, 2012, 08:58 AM
Rhonda
Hi Do you have ReportCaster? That would keep a log of every time a report has been run and whether it was scheduled or not. Th only other thing I can think of is to write a MODIFY that would populate a database with the information, however, that would involve kicking off the MODIFY for every report you want a record. ReportCaster is definitely cleaner.
Rhonda
WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
December 13, 2012, 09:34 AM
susannah
come to Summit...Usage Tracking presentation
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 13, 2012, 10:10 AM
Rhonda
Great reminder Su! I forgot about that presentation. Thank for reminding us all! I can't remember which Summit it was presented? 2011 or 2012? I am sure we all would like to review.
Thanks, Rhonda
WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
December 13, 2012, 10:53 AM
susannah
2013...
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 13, 2012, 12:18 PM
Rhonda
I thought it was from 2011 or 2012! I thought it was a presentation that I had not attended but saw posted. LOL
Rhonda
WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
December 14, 2012, 07:27 AM
Deepu
quote:
Originally posted by Rhonda: Hi Do you have ReportCaster? That would keep a log of every time a report has been run and whether it was scheduled or not. Th only other thing I can think of is to write a MODIFY that would populate a database with the information, however, that would involve kicking off the MODIFY for every report you want a record. ReportCaster is definitely cleaner.
Rhonda
Hi we are not using ReportCaster gust we are running the report manually.