COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bioCam on 31 Oct 2011 08:38:59 AM

Title: Run a report and schedule the same report?
Post by: bioCam on 31 Oct 2011 08:38:59 AM
Hi, the report is run and viewed by the user community.  There is a datetime prompt value (shows the last 24 hour, by the date/hour) which the user can select as criteria to run the report.  If user runs the report a a few minutes after the hour, they get new information.  Then there is this other group of users who only want to see the report with the latest datetime data sent to them in an email (to be run in the morning).

Do I need 2 similar reports?  1st report - user can select the time.  2nd report to be scheduled in the morning - only contains the latest time data (since I cannot use a dynamic parameter to only select the latest time data).

Is there a method to achieve both using 1 report?  Thank you


Title: Re: Run a report and schedule the same report?
Post by: rockytopmark on 01 Nov 2011 04:07:23 PM
You could probably get away with using 1 report.

Update the filter (I assume already exists) to first check if the Datetime parameter has been set.  If the parm has not been set (IS NULL) then filter the report on the maximum([query subject].[datetime_field]),  else filter on the Parameter value when it isn't NULL

HTH .... M