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.
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
Thanks chris .
But it doesnt say anything about the scheduling part, how do I send current_date to a report with a date prompt ?
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.