Stored Procedure
Stored Procedure
(OP)
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
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
Talk To Other Members
RE: Stored Procedure
If you're not getting an error, then the SP is firing.
Are you sure that you're passing the proper parameters?
-k