Skip to Content
0
Former Member
Jul 19, 2016 at 11:02 AM

Dynamic Prompt for weekly report

73 Views

I have to make an automated weekly report from a big Universe. When I run the query, I am prompted for the Invoice Start Date and Invoice End Date (based on the Invoice Date variable). Now, my Invoice Start Date is fixed but the Invoice End Date has to be the Current Date (the date when the query is executed). I do not want to manually select the Invoice End Date every time the query is executed. Is there any way this can be automated?

I have to also schedule the query weekly. But that is not a problem. The only problem is how to automate the Invoice End Date prompt.

To make things more clear, I will be scheduling the query to run on every Monday.

Thanks for the help.

P.S. I am using BO WebI 4.0