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