Estoy ejecutando un Stored Procedure desde un informe en Base y corre sin problema, el tema es que al momento de agregar una agrupacion desde el reporte me manda un error. Base de Datos Mysql

La forma en como estoy ejecutando el SP es:

          CALL spConformacionReporte();

Error:

org.libreoffice.report.ReportExecutionException: [MySQL][ODBC 5.1 Driver][mysqld-5.6.44-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CALL spConformacionReporte():wink: “__LibreOffice_report_result”’ at line 1
org.libreoffice.report.ReportExecutionException: [MySQL][ODBC 5.1 Driver][mysqld-5.6.44-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CALL spConformacionReporte():wink: “__LibreOffice_report_result”’ at line 1
at org.libreoffice.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:350)
at org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:217)
Caused by: org.jfree.report.ReportDataFactoryException: [MySQL][ODBC 5.1 Driver][mysqld-5.6.44-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CALL spConformacionReporte():wink: “__LibreOffice_report_result”’ at line 1
at org.libreoffice.report.pentaho.StarReportDataFactory.queryData(StarReportDataFactory.java:68)
at org.jfree.report.data.CachingReportDataFactory.queryData(Unknown Source)
at org.jfree.report.data.ReportDataRow.createDataRow(Unknown Source)
at org.jfree.report.flow.DefaultFlowController.performQuery(Unknown Source)
at org.jfree.report.flow.layoutprocessor.ReportLayoutController.startData(Unknown Source)
at org.jfree.report.flow.layoutprocessor.ElementLayoutController.startElement(Unknown Source)
at org.jfree.report.flow.layoutprocessor.ElementLayoutController.advance(Unknown Source)
at org.jfree.report.flow.AbstractReportProcessor.processReportRun(Unknown Source)
at org.jfree.report.flow.SinglePassReportProcessor.processReport(Unknown Source)
at org.libreoffice.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:338)
… 1 more

Ya pude resolver mi problema… lo que hice fue crear una tabla temporal dentro del SP y despues lo consumo el resultado desde el reporte con un simple Select de la tabla