MySQL Stored Procedures with Parameters in Crystal Reports 9?

30 pts.
Tags:
Crystal Reports 9
MySQL
MySQL Stored Procedures
Stored Procedures
Hi, I'm using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I do:
CREATE DEFINER=`admin`@`localhost` PROCEDURE `sp_Report`(IN vClientID CHAR(7))
 BEGIN
         SELECT CONCAT(Clients.FirstNames, ' ', Clients.Surname) AS ClientName
         FROM   Clients
         WHERE  Clients.ClientID = vClientID;
 END
Can anybody help? Please? I used pretty much the same process while I used SQLServer2000, I think the issue now is MySQL stored procs are called different from SQLServer stored procs. It may be interesting to note that the Crystal accepts stored procedures that do not have parameters!

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can just call the stored prcedure from within Crystal once you have created it eg;

call sp_Report({?clientID})

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: