SIMS Reports for automated AD Pupil accounts
I'm not really sure if this is one for your guys as it's more of an administration thing really. What i am wanting to do is design a report in SIMS.net which will run every night/morning checking for new admitted Pupils. The report would extract these pupils into a .CSV file which in turn would be used to create their accounts in the AD for them to log in.
I have looked at designing a report but it doesn't seem to have the flexibility i need to create the reports on the fly without prompts. I want to be able to specify the current date for each day and have it return the admitted pupils for that day, therefore giving me the new users each time if there are any. It seems to only allow me to choose on prompt.
Does Sims. net have the power that i need to create such a task?
I also need it to be able to overwrite the .csv file each time the report is run without being asked.
Hope you can help.