Hello,
I've been stumped by this issue that I've been getting. I've been trying to take advantage of stored procs to filter the result set before returning to CR instead of using views, which relies on most of its filtering on the crystal reports side.
I've followed the process of creating the strongly bound cursor, then including an "in out" parameter along with 5 other "in" parameters in the stored proc. In the Java class, this is how I pass in the parameters:
ReportClientDocument reportClientDoc = new ReportClientDocument();
reportClientDoc.open(REPORT_NAME, 0);
//Connection setup
ConnectionService.getInstance().crytalReportsConnectionSetup(reportClientDoc.getDatabaseController());
//We will be using the ParameterFieldController
ParameterFieldController paramFieldController = reportClientDoc.getDataDefController().getParameterFieldController();
paramFieldController.setCurrentValue("", "PARAM1", "000");
paramFieldController.setCurrentValue("", "PARAM2", "000");
paramFieldController.setCurrentValue("", "PARAM3", "000");
paramFieldController.setCurrentValue("", "PARAM4", "000");
paramFieldController.setCurrentValue("", "PARAM5", "000");
I end up getting an error:
Invalid Parameter Name:
I've tested the report itself in Crystal and it works. Is there something I'm missing?
Thanks in advance,
Jeff