<div>
Glad i could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I need to generate some reports in batch during a nightly routine. &nbsp;I have a crystal report template already built (.rpt). &nbsp;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. &nbsp;<br />
<br />
I'm sure this can be done but I'm not sure how to Instantiate the Crystal Object, and then export a pdf doc. &nbsp;In fact, I'm not even sure what the syntax would be however I do have experience calling various other objects via SQL Server<br />
<br />
Any Help would be greatly appreciated.
</div>
</div>


Hi Experts

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.

Generate CRYSTAL REPORT in PDF Format in Batch directly from SQL SERVER

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.