Stored Procedure

[dkohli]

Hello,

I am trying to create a report from a SQL Server Stored procedure. But whenever I connect to the ODBC and select the stored Proc, the name of the stored proc is added by ;1

For example the name of the SP is select_customer. I go to the report expert - > Databases -> ODBC. The name of the SP is database.owner.Proc(select_customer;1).

If I go to the "Show SQL Query" I get:
{call database.dbo.select_customer;1(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

So when I execute this report, it does not get any records since a SP by that name never exists. I have created several ODBC connections (both from control panel and from Crystal). I have also un-installed and re-installed crystal...but no luck.

If anyone can tell me what is getting wrong..I will greatly appreciate that.
Thanks
DK

 

[synapsevampire]

Crystal adds that and it doesn't prevent the SP from running.

If you're not getting an error, then the SP is firing.

Are you sure that you're passing the proper parameters?

-k