[sims] Autoschedule reports - Date problems

[emmaburt26]

Can anyone give some advice please.

i have set up auto scheduler for reports and have been doing some tests with reports. i can get them to run and turn up in my reports section on sims, however i have a daily report which is a detention register and i want it to pick up the pm attendance marks for students onto the report. Is there any way of telling sims that you want the date to me 'today' each day when it runs it rather than a specific date in time?

 

I have tested this report over the last two days and the first day is fine and it has the correct information but the second day is still taking the attendance marks from the day before as i can't see how to tell it to always use the current date as the filter.

 

Any ideas?!

 

Emma

[vikpaw]

to EduGeek

I know there is a problem surrounding dates and particularly date ranges when trying to script reports using command reporter and also scheduling, but I don't know if this affects what you're trying to do.

Usually for a regular report, if setup correctly, it will run based on Today, so I would hope it does the same through the Auto Schedule routine.

Can you confirm that it works as expected when you run it manually?

 

When you design a report one of the first screens covers the effective date - this can be set to default to the current date. If however, your report is prompting you for another date as part of a sub-report or one of the filters, then that won't pull through when you schedule it.

 

If this is the case you may have to look at scripting it using command reporter and seeing if it's possible to pass the date parameter in at run time, it will be a lot more complex, but there are a fair few threads here that go over parts of the process.