If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Run a report and schedule the same report?

Started by bioCam, 31 Oct 2011 08:38:59 AM

Previous topic - Next topic

bioCam

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



rockytopmark

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