Importing stored procedure into crystal

[RNewton25]

I have a stored procedure written in sql; my company would like to take this procedure and import it into Crystal 8.5 to use. I have checked the crystal decisions site; but can anyone offer advice on this.

Thank you very much.

 

[lyanch]

That all depends on what you mean by "importing". If you mean that you want to access the data that the stored procedure returns, then yes. You merely need to select the stored procedure as your datasource.

If you mean that you want to replicate the stored procedure within crystal so that you don't have to call the SP but get the same data straight from crystal SQL.... well it all depends. There is no "import" in crystal 8.5 for SQL statements, mostly because crystal can't handle the complicated statements/multiple queries etc that SP's normally use. *if* you can simplify the SP into a single SQL statement.. then *maybe* you can get the SP into crystal.

Lisa

 

[rosemaryl]

Dear RNewton25,

Here you go - Crystal document on Stored Procedures:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/storproc.pdf.asp

This is a Crystal Technical Paper on Stored Procedures

You can find a lot of information here that doesn't pop up in a KB Search:

http://support.crystaldecisions.com/library

By the way, I have used them to report off of and they are pretty easy and fast!


ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.