Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schedule Report in IWR with dynamic prompt values

Status
Not open for further replies.

dagwoodnil

Programmer
Dec 11, 2002
10
0
0
CA
We have approximately 10 reports that we pre-run for our end users based on their territories. This translates to approx. 100 reports. The reports extract data from the previous month. There is a picklist prompt for the month that we have to manually select each month to extract the correct data.
What I need help on is to find a method to select the right prompt value dynamically when I schedule the report to run monthly.

Can you help?
Thanks
Nathan
 
If it's a scheduled report, why not just change the filter and remove the prompt?

I am what I am based on the decisions I have made.

DoubleD [bigcheeks]
 
Nathan - If DoubleD's reply doesn't help, have a look at my reply to thread401-829522. I know that's not for IWR (which I have no experience with), but you might be able to apply the concepts.
Simon Rouse
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top