I need to generate some reports in batch during a nightly routine. I have a crystal report template already built (.rpt). Each night I want to have a SQL Stored Procedure fire off via a Job and create the report for each record in PDF format.
I'm sure this can be done but I'm not sure how to Instantiate the Crystal Object, and then export a pdf doc. In fact, I'm not even sure what the syntax would be however I do have experience calling various other objects via SQL Server
Any Help would be greatly appreciated.