COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sri576 on 16 Oct 2008 03:23:31 AM

Title: need help
Post by: sri576 on 16 Oct 2008 03:23:31 AM
hello gurus,
I have a requirement like am comparing records from 2 tables
of different databases.I implemented 2 date&time prompts from_date
and to_date to compare the data within specified date ranges.
everything works fine...but now the problem is the report has to be
scheduled to run daily so i have to provide default selection
for each date prompt.
for ex...
for to_date prompt it should take the system date & time and for
from_date previous day date ie, the date&time of last successful
execution of the report. 
need your help...
thnax
sree
Title: Re: need help
Post by: sri576 on 20 Oct 2008 09:32:40 AM
Can any one give brief idea...............
pleas....
sree