[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

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.
0
lsrbby
Asked:
lsrbby
  • 2
1 Solution
 
mlmccCommented:
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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now