Hello Folks,
I tried looking up the forums but I could not find a solution. If this is a repetitive post please direct me to the
right post.
Report needs to run daily for previous week.I can code this based on _day_of_the_week and case statement.
This will work with the scheduler. I can schedule it to run every day.
But I also have a prompt page and what I really need is the ability to change the dates in the prompt page when I want a different week or month.
I tried to specify default in the filter . When I try to schedule it i unchecked the Prompt for values.
But it doesn't work.
[Date] between #prompt('FromDate','date','_add_days(current_date,-8)')#
and
#prompt('ToDate','date','_add_days(current_date,-1)')#.
Found a solution from previous posts.
Thank you Nimrod Avissar.
http://www.cognoise.com/index.php?topic=26481.0