Getting a stored procedure into CR

[RobbieB]

Someone in our company sent me the sql for a report in a custom AP. I am using CR9 and can't just copy the sql into the report. The SQL makes several references to stored procedures. I can connect to the data source but do not know how to "get the stored procedures into Crystal". If I try to add it as a data source it references parameters and wants a number input. If I put a number in it gets an the error "Query Engine Error: '42000 [Microsoft][ODBC sql server Driver][SQL Server]Line 1: Invalid Procedure Number (0). Must be between 1 and 32767.' When in fact I am putting in a number in this range. Any suggestions?

 

[dgillz]

Under file, options, database tab, make sure the "stored procedures" checkbox is checked. Then just point to it like it was a table, and go from there.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[RobbieB]

I tried that and when I add it, it asks me for a customer number. That is when I get the error.

 

[SurfingGecko]

This looks to me like a rights issue on the proc itself.

What is on line 1 of the proc?
Maybe post it here for us to see


Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[synapsevampire]

What connectivity are you using to the database? If ODBC, make sure that you use the Crystl supplied ODBC driver.

Otherwise, I'd guess that the SP is wrong, though you used the term AP, what do you mean by that?

-k

 

[RobbieB]

Sorry, by AP I meant APP - application. We have a custom application for "ski school" and I am trying to pull a stored procedure into a new Crystal Report I am writing. I am using the Crystal supplied ODBC driver.

 

[SurfingGecko]

Have you looked at the proc yet? What is the proc looking for at line 1?



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease