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

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.
lsrbbyAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I don't believe you can do it directly from SQL.  However you probably can kickoff a VB application that could run the report.

I don't think Crystal supports an interface like you need to databases only to their applications.

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.