VBS to Run Report on Enterprise Server and Output to File
Posted on 2006-05-16
I am looking for a way to have a nightly VBS script run an activity report on our Enterprise Server for each employee and email it to them. There is a single RPT report and the script would provide the date range and employee name as parameters; then repeat for each employee.
I have some very specific requirements for the body of the email, so I'm planning on generating it through the script, not using Crystal's email feature. My plan is to make Crystal output the finished report to a known location in PDF format so my script can grab it and attach it to the email.
I know how to use VBS to create the email and attach the file and I have a very limited understanding of Crystal's COM objects. I really need help knowing how to pass the parameters and specify the output file's name and destination.