Question

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

Crystal Reports 9, MySQL, Stored procedures, Parameter Stored Procedures, MySQL 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!

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

call sp_Report({?clientID})