Solved

Calling Crystal Reports from SSIS pkg

Posted on 2008-10-03
3
1,351 Views
Last Modified: 2013-11-10
Hi Guys just a quick question, is it possible to call a report from Crystal 11 from a SSIS pkg.?
If so can someone point me to an article that explains how it is done?

Thanx much,
Trudye
0
Comment
Question by:Trudye
3 Comments
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22641427
Trudye,
Do you already call from a .Net application? Or do you know the code to call from an .net application?
If so, you only need to copy paste to inside a script task in SSIS.
Regards!
0
 

Author Comment

by:Trudye
ID: 22645969
No I don't code .NET. Is that the only way to call Crystal reports from an SSIS pkg?
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 22652277
There are quite a few Crystal Viewers out there, one I use is EasyStreet and has a command line interface (not that I have ussed that bit) : http://www.easystreetsoftware.net/Products/EasyView_Main.php and groff automation has a delivery option for command line : http://homepages.udayton.edu/~groffkep/

for a few options, including code sample, have a look at : http://www.kenhamady.com/bookmarks.html

OK, the reason for the above is you simply create a processtask setp and launch your Crystal Report from the command line.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question