CODEWITHSUNDEEP
cognos
chemicalkt
chemicalkt

Reputation: 816

macro prompt not getting refreshed in scheduled report

I have a date prompt which is set to default to today's date using a prompt macro. The report is scheduled to run daily using today's date but every day it runs it takes the date on which the report was scheduled. My schedule says to run the report and not just view the report.How do I schedule a report to run using refreshed dates? (cognos 10.1)

Upvotes: 0

Views: 1846

Answers (2)

Nick.Mc
Nick.Mc

Reputation: 19205

Javascript does not run for scheduled reports because there is no 'browser' for it to run in. If you have been scheduling your reports and providing a value for your date parameter then that explains it - your macro prompt will not use a default, ti is using a fixed parameter value instead.

Also on the actual prompt page make sure the prompt is not required.

Upvotes: 1

Deepa
Deepa

Reputation: 411

In addition to using prompt macro, you will have to include JavaScript to pre-select the dynamic date values within the date prompt.

This article on developerWorks details the necessary steps, prompt macro and Javascript to set dynamic default values for date prompts.

http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page634/

Upvotes: 0

Related Questions