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))
SELECT CONCAT(Clients.FirstNames, ' ', Clients.Surname) AS ClientName
WHERE Clients.ClientID = vClientID;