You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to schedule an OTBI report to generate monthly with dynamic prompt?

Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically populate with the first day of the prior month. For example, I'd like the report to run on August 1st and have the datetime prompt automatically populate with July 1st (in datetime format). And then on September 1st have the report automatically run and have the datetime prompt automatically populate with August 1st (in datetime format). And so on. How can I go about this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!