Crystal Report run through DTS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Crystal Report run through DTS

12 posts, Page 1 of 2

1 2 »»

Crystal Report run through DTS

Rate Topic

Display Mode

Topic Options

Author

Message

petersobeco

Posted Tuesday, May 12, 2009 11:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 05, 2009 8:21 PM
Points: 8, Visits: 14

Hi,

I just run crystal report daily without any parameter and after run, save the file in c:\temp directory. I have created many DTS but I dont know how can I run my crystal report which has no paramter and save result in pdf format. Please help.
Thanks.

Post #715664

spaghettidba

Posted Wednesday, May 13, 2009 1:31 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:29 AM
Points: 4,804, Visits: 8,067

In order to export Crystal Reports to PDF you have to write some code in an ActiveX script task. I must say that it's not so simple, since I had to do it myself too. I set up a small utility to perform this task. You can find it attached here.

The zip contains 3 files:

RPTExport.dll
PDFExport.exe
PDFExport.ini

To make it work:

1) register RPTExport.dll (run "regsvr32 RPTExport.dll")
2) edit PDFExport.ini and set up your connection properties
3) run PDFExport.exe with appropriate parameters

SYNTAX:
--------------------------------
PDFexport reportFile=file
exportFile=file
[selectionFormula=formula]
[param=paramName;paramValue;{True|False}]
...
[param=paramName;paramValue;{True|False}]

ARGUMENTS:
---------------------------------
reportFile Path to report (file .rpt)
exportFile Path to export File
selectionFormula Selection formula
param Report parameter

Usually I don't run binary code from people I don't know, so I won't be surprise if you don't like the idea of running mine. If you want I can provide the full source code (Visual Basic 6).

Hope this helps
Gianluca

Get your two-cent-answer quickly
The Spaghetti DBA

Post Attachments

PDFExport.zip (7 views, 42.36 KB)

Post #715706

remo 57808

Posted Thursday, August 23, 2012 3:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 3:20 AM
Points: 5, Visits: 6

Hi I just tried to use your solution with a crystal report (version 9) and it reposnds with the following error;

"C:\Program Files\Crystal Decisions\PDFexport\PDFExport>pdfexport reportFile=prod
uctsalesbymonth.rtp exportFile=test param=ProdCode;CUM001

Invalid object name 'LABELS'."

Am i doing somthing wrong???? Sad

Post #1348977

spaghettidba

Posted Monday, August 27, 2012 2:25 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:29 AM
Points: 4,804, Visits: 8,067

I see...
The application looks fro a LABELS table that contains all the labels in the report for translation in other languages.
That's something I failed to remove from this project and was set up that way in my environment.
You could create a LABLES table (I don't remember the definition offhand, but you could guess it upon error messages).
Otherwise I would have to look up the code (given that I still have it lying somewhere) and post it again.

Regards
Gianluca

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1350254

remo 57808

Posted Tuesday, August 28, 2012 5:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 3:20 AM
Points: 5, Visits: 6

thanks for your rapid reply... to save time can you remeber if this solution support Crystal 9?

Post #1350844

spaghettidba

Posted Tuesday, August 28, 2012 7:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:29 AM
Points: 4,804, Visits: 8,067

It should work with CR 9.
Have you tried creating the table?

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1350932

keypax2012

Posted Wednesday, October 03, 2012 3:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 3:38 AM
Points: 1, Visits: 4

ActiveX component can't create object

Post #1367482

remo 57808

Posted Wednesday, October 03, 2012 3:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 3:20 AM
Points: 5, Visits: 6

Hi there, unfortunately it isn’t possible to create a table due to the way we have crystal implemented in our business. Sad

Is there a way to get around this problem? It looks like this is just what I am looking for so it is a real shame I am having this problem. Any help you can throw my way would be greatly appreciated. Smile

Post #1367487

Uripedes Pants

Posted Thursday, October 04, 2012 9:31 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:58 PM
Points: 595, Visits: 3,893

I use a program called "CutePDF". you can google for it and find the download site. It installs as a printer driver. All you have to do is "print" to the printer "CutePDF Writer" and it saves your document as pdf file.

Post #1368510

remo 57808

Posted Thursday, October 04, 2012 9:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 05, 2012 3:20 AM
Points: 5, Visits: 6

hi there, i need it to be a command line application so that i can export a Crystal report to a PDF from a DTS in SQL server without any manual intervention.

Post #1368521

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions