Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Crystal Report run through DTS Expand / Collapse
Author
Message
Posted Tuesday, May 12, 2009 11:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 5, 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
Posted Wednesday, May 13, 2009 1:31 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:49 PM
Points: 4,324, Visits: 10,583
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


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba


  Post Attachments 
PDFExport.zip (7 views, 42.36 KB)
Post #715706
Posted Thursday, August 23, 2012 3:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 5, 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????
Post #1348977
Posted Monday, August 27, 2012 2:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:49 PM
Points: 4,324, Visits: 10,583
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


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1350254
Posted Tuesday, August 28, 2012 5:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 5, 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
Posted Tuesday, August 28, 2012 7:40 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:49 PM
Points: 4,324, Visits: 10,583
It should work with CR 9.
Have you tried creating the table?


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1350932
Posted Wednesday, October 3, 2012 3:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 3:38 AM
Points: 1, Visits: 4
ActiveX component can't create object
Post #1367482
Posted Wednesday, October 3, 2012 3:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 5, 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.
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.
Post #1367487
Posted Thursday, October 4, 2012 9:31 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 7, 2014 11:41 AM
Points: 703, Visits: 4,519
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
Posted Thursday, October 4, 2012 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 5, 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 »

Add to briefcase 12»»

Permissions Expand / Collapse