executing CommandReporter from scripts
I've seen a few posts on here regarding people using commandreporter to generate/automate running the reports and exporting .xml files.
For a while now ive been creating a set of templates in excel to create graphs/student/department/behaviour profiles for students etc. command reporter is very usefull and plays right into my hands having based my excel template files on reading xml reports.
I've got my head around the param files and using filters and have now got a batch script running as a scheduled task.
The script essentially does the following: open and excel file with auto_open macro that >Works out the date range for last week for the report parameters > generates a prama.xml file for the command report (to make the date rang dynamic)> closes the excel file> Runs commandreporter> opens the excel template for the chart/profiling sheet i'm using> this then reads the XML output from the report and emails PDF's to departments/people etc in the template.
Setting up the reports has reduced so many repetitive tasks but i think i could refine this further. I looking to code this further/simplifiy how I've done this and am think maybe .Net or something may help.
Has anyone else gone down this route themselves or have people tended to buy in software from other vendors.