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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!