MySQL Stored Procedures with Parameters in Crystal Reports 9???

30 pts.
Tags:
Crystal Reports 9
MySQL
MySQL Stored Procedures
Parameter Stored Procedures
Stored Procedures
Hi, am 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!
ASKED: May 12, 2008  11:10 AM
UPDATED: May 20, 2008  7:57 AM

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following