How to schedule a report by passing current_date to the prompt in the report

[katdbc]

Can any anybody help me on "How to schedule a report by passing current_date to the prompt in the report" .Im using cognos 10.1

I tried to do this by using a if  statement in the report to selectively filter from a static choice passed during run time from the scheduler.

I haven't used macros before. Can anybody help me with a macro solution. Im sure this is a repetitive question but for some reason I couldnt find the proper link. If anybody can point me in a right direction. I would be very thank ful.

[BigChris]

I wrote a blog post on this sort of thing...mostly so that I've an aide memoire on how to do it. See if this helps you at all:

http://cognostips.weebly.com/blog/date-prompts

C

[katdbc]

Thanks chris .

But it doesnt say anything about the scheduling part, how do I send current_date to a report with a date prompt ?

[BigChris]

When you schedule the report you can just click on the prompts and select the option you want the schedule to run for. I haven't put current date or yesterday in the list, but you should be able to extend the logic to cover what you need.