using 'Last sucessfull report run date'

[murthyvasan]

 Hi,

Ã,  Ã,  I have to report on the differences between tables in one database.

Initially , I will be scheduling my report to run on everyday and have a date filter in each report, which will bring the records which are added/updated just one day prior to the schedule date. My Filter will be like

where Date >= 'Sysdate' - 1

Suppose the report runs sucessfully on Jan 3rd, Jan 4th but failed on Jan 5th, the report on Jan 6th should show the data between Jan 4th( the last sucessfull report run date) and Jan 6th , and not between Jan 5th and Jan 6th. The filter in Jan 6 report has bring in the records from Jan 4th. In order to do this, I need to filter on 'Last
Successfull Report Run date' for all my reports rather than just one day prior to the scheduled date. How would I get this 'Last Sucessfull Report Run date' value? My filter condition will be like

Date >= 'Last Sucessfull Report Run Date'

I can look at the 'Run history' in Schedule Management, but this becomes manual.

In addition to the above scheduling, I already created the same report with prompts, so that the user can enter the 'Start Date' and ' End Date' and report diplays all the record inbetween. As this is an urgent issue , I would be gratefull if I get help ASAP.I'm using cognos 8