MySQL Stored Procedures with Parameters in Crystal Reports 9???
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:
Software/Hardware used:
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! Software/Hardware used:
ASKED:
May 12, 2008 11:10 AM
UPDATED:
May 20, 2008 7:57 AM
Answer Wiki:
You can just call the stored prcedure from within Crystal once you have created it eg;
call sp_Report({?clientID})
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
