MySQL Stored Procedures in Crystal Reports
MySQL, Crystal Reports, MySQL Stored Procedures, Crystal Reports 9
Hi,am using Crystal Reports 9 and 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
