Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] last run date of the Reports
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] last run date of the Reports
 Login/Join
 
Gold member
posted
Hi

Can anyone give me solution for this

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 Manually

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 6 | Registered: September 26, 2012Reply With QuoteReport This Post
Master
posted Hide Post
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?


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi

Could you Please give me one sample ex how to do

that will be grateful to me & thanks

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_Month

This message has been edited. Last edited by: Deepu,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
come to Summit...Usage Tracking presentation




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
2013... Smiler




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I thought it was from 2011 or 2012! I thought it was a presentation that I had not attended but saw posted. LOL Good One

Rhonda


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
 
Posts: 146 | Location: Atlanta, GA | Registered: May 31, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
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.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] last run date of the Reports

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.