Hi,
I'm trying to run a simple report I create using Crystal Reports XI. It simply calls a stored procedure as follows:
CALL RPT_work.testReport("{?input1}", "{?input2}");
This returns the two inputs as two one row columns.
I managed to run reports which require no parameters (so the problem is not due to connectivity) but I'm getting the following error when I try to run reports which use parameters:
Failed To Retrieve Data From Database
Details: [Database Vendor Code: 1312])
Can you please help me solve this problem?
Note: Below please find the stored procedure I'm calling:
DELIMITER //
DROP PROCEDURE IF EXISTS RPT_work.testReport //
CREATE PROCEDURE RPT_work.testReport(IN input1 char(50), input2 char(50))
BEGIN
SET @para1 = input1;
SET @para2 = input2;
SELECT CAST(@para1 AS CHAR(10)) AS para1,
CAST(@para2 AS CHAR(10)) AS para2;
END;
//
DELIMITER ;
Attachment testReport2.zip not found