Open Business Intelligence

La red del Business Intelligence

quisiera saber como se declara una variable en la consulta de pentaho report o

como funciona el SET en pentaho quiero declarar algo asi

SET @row := 0 pero me marca error en pentaho

Visitas: 679

Responde a esto

Respuestas a esta discusión

org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SET @row=0;
SELECT (@row:=@row+1) AS rownum,
     `alumno`.`Alum_Exp`,
     `alumno`.`Alum_id`,
     `maestros`.`nombre`,
     `materias`.`Mat_Nombre`,
     `materias`.`Mat_Clave`,
     `expediente`.`Calificacion`,
CONCAT_WS('  ', `Alum_ApPaterno`, `Alum_ApMaterno`, `Alum_Nombre` ) AS `Alumno`,
(SELECT SUM(`expediente`.`calificacion`) from `expediente` where `expediente`.`Mat_ID` = `materias`.`Mat_ID`)as `suma`,
(SELECT DATE_FORMAT(CURDATE(),'%d/%m/%y'))as `fecha`,
(SELECT DATE_FORMAT(Ciclo_Nom,'%y-%m'))as `ciclo`
FROM  `maestros` left JOIN `materias` ON (`maestros`.`Mat_ID` = `materias`.`Mat_ID`)
     left JOIN `expediente` ON (`materias`.`Mat_ID` = `expediente`.`Mat_ID`)
     left JOIN `alumno` ON (`expediente`.`Alum_ID` = `alumno`.`Alum_ID`)
     left JOIN `ciclo` ON (`expediente`.`Exp_ID` = `ciclo`.`Exp_ID`)
where `materias`.`Mat_ID` = ${materias}

order by `Alumno` asc

 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254)
 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
 at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:90)
 at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:249)
 at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:206)
 at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:99)
 at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
 at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
 at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:287)
 at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:469)
 at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:79)
 at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:273)
 at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)
ParentException:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ';
SELECT (@row:=@row+1) AS rownum,
     `alumno`.`Alum_Exp`,
     `alumno`.`Alum' at line 1
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)
 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:412)
 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:250)
 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)
 at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:90)
 at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:249)
 at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:206)
 at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:99)
 at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
 at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
 at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:287)
 at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:469)
 at org.pentaho.reporting.engine.classic.core.modules.output.pageable.graphics.PrintReportProcessor.getNumberOfPages(PrintReportProcessor.java:79)
 at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane$RepaginationRunnable.run(PreviewPane.java:273)
 at org.pentaho.reporting.engine.classic.core.util.Worker.run(Worker.java:174)

 

 

cual sera mi error?? se que es el set pero como lo cambio?

Responder a debate

RSS

Distintivo

Cargando…

© 2024   Creado por Emilio.   Tecnología de

Emblemas  |  Reportar un problema  |  Términos de servicio