Skip to Content
0
Former Member
Mar 24, 2009 at 11:52 PM

stored procedures for CR using MySQL Navicat 8

139 Views

Has anyone used Navicat 8 to write a stored procedure for Crystal Reports?

I am trying to include a parameter in this simple example to pass to a Crystal Report. The following works in the applications stored procedure designer:

BEGIN

SELECT * FROM TempSales WHERE SaleID > SaleIDParam;

END

However, if I want to reference a parameter on a crystal report i have to have the @ or ? symbol before the SaleIDParam. When I do this the procedure does not run.

Note with the designer you don't have to have the DELIMITER or the PROCEDURE statements.