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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Filtering 1

Status
Not open for further replies.

ganjass

Technical User
Dec 30, 2003
154
GB
CE10

Hi All,

I have a large number of reports that are to be scheduled. The only thing that differs is the account codes being used in the reports, that and the date range, rather than save multiple instances of the report to CE, is there a way that filters can be dynamically assigned to one generic report on a schedule for ultiple instances of records selection.

Thanks in advance
 
Hi,
Just a thought,after seeing many requests for this type of functionality..

Maybe some kind of selection formula using a CASE statement based on the Time portion of the current date to determine the criteria..Then schedule an instance of the report to run within the time ( preferably a time range of several minutes to allow for delays in starting) specified for each record selection needed.

Never tried it, but it seems like it could work ( especially for those reports that only have 5-10 variants )

It is still multiple schedules, but just 1 report.
Any thoughts?

[profile]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top