Este es el método que utilizo para crear mi reporte...
private void AbrirAsistencaSemanal(){
try {
Connection conexion = ConMsSQL.obtenerConexion();
ClassLoader cl = getClass().getClassLoader();
InputStream in =cl.getClass().getResourceAsStream("/Reportes/rpt_AsistenciaSemanales.jasper");
HashMap objHashMap=new HashMap();
objHashMap.clear();
objHashMap.put("fecha",formDataJava(txtFechaSemana lAsistencia.getDate()));
JasperPrint objJasperPrint=JasperFillManager.fillReport( in ,objHashMap,conexion);
JDialog jDialogMostrar =new JDialog(this,"Asistencia Consolidada de la Semana", true);
jDialogMostrar.setDefaultCloseOperation(javax.swin g.WindowConstants. DISPOSE_ON_CLOSE);
jDialogMostrar.setSize(950, 715);
jDialogMostrar.setLocationRelativeTo(null);
JasperViewer oViewer = new JasperViewer(objJasperPrint,false);
jDialogMostrar.getContentPane().add(oViewer.getCon tentPane());
jDialogMostrar.setVisible(true);
javax.swing.JDialog.setDefaultLookAndFeelDecorated (true);
oViewer.dispose();
objJasperPrint=null;
jDialogMostrar.dispose();
jDialogMostrar=null;
} catch (Exception e) {
e.printStackTrace();
JOptionPane.showMessageDialog(rootPane, "Error...");
}
}
y este es el error que me sale...
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : null
at net.sf.jasperreports.engine.query.JRJdbcQueryExecu ter.createDatasource(JRJdbcQueryExecuter.java:169)
at net.sf.jasperreports.engine.fill.JRFillDataset.cre ateQueryDatasource(JRFillDataset.java:684)
at net.sf.jasperreports.engine.fill.JRFillDataset.ini tDatasource(JRFillDataset.java:605)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setP arameters(JRBaseFiller.java:1281)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:901)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:845)
at net.sf.jasperreports.engine.fill.JRFiller.fillRepo rt(JRFiller.java:58)
at net.sf.jasperreports.engine.JasperFillManager.fill Report(JasperFillManager.java:417)
at net.sf.jasperreports.engine.JasperFillManager.fill Report(JasperFillManager.java:378)
at Ventana.Reportes.AbrirAsistencaSemanal(Reportes.ja va:728)
at Ventana.Reportes.ActivarReporte(Reportes.java:886)
at Ventana.Reportes.jButton2ActionPerformed(Reportes. java:484)
at Ventana.Reportes.access$1000(Reportes.java:26)
at Ventana.Reportes$11.actionPerformed(Reportes.java: 451)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.jav a:6290)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3267)
at java.awt.Component.processEvent(Component.java:605 5)
at java.awt.Container.processEvent(Container.java:203 9)
at java.awt.Component.dispatchEventImpl(Component.jav a:4653)
at java.awt.Container.dispatchEventImpl(Container.jav a:2097)
at java.awt.Component.dispatchEvent(Component.java:44 81)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4575)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4236)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4166)
at java.awt.Container.dispatchEventImpl(Container.jav a:2083)
at java.awt.Window.dispatchEventImpl(Window.java:2489 )
at java.awt.Component.dispatchEvent(Component.java:44 81)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:648)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:607)
at java.awt.EventQueue$1.run(EventQueue.java:605)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:621)
at java.awt.EventQueue$2.run(EventQueue.java:619)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 618)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:178)
at java.awt.Dialog$1.run(Dialog.java:1044)
at java.awt.Dialog$3.run(Dialog.java:1096)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1094)
at java.awt.Component.show(Component.java:1584)
at java.awt.Component.setVisible(Component.java:1536)
at java.awt.Window.setVisible(Window.java:843)
at java.awt.Dialog.setVisible(Dialog.java:984)
at Main.MenuPrincipal.jButton3ActionPerformed(MenuPri ncipal.java:809)
at Main.MenuPrincipal.access$500(MenuPrincipal.java:3 7)
at Main.MenuPrincipal$6.actionPerformed(MenuPrincipal .java:344)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.jav a:6290)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3267)
at java.awt.Component.processEvent(Component.java:605 5)
at java.awt.Container.processEvent(Container.java:203 9)
at java.awt.Component.dispatchEventImpl(Component.jav a:4653)
at java.awt.Container.dispatchEventImpl(Container.jav a:2097)
at java.awt.Component.dispatchEvent(Component.java:44 81)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4575)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4236)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4166)
at java.awt.Container.dispatchEventImpl(Container.jav a:2083)
at java.awt.Window.dispatchEventImpl(Window.java:2489 )
at java.awt.Component.dispatchEvent(Component.java:44 81)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:648)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:607)
at java.awt.EventQueue$1.run(EventQueue.java:605)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:621)
at java.awt.EventQueue$2.run(EventQueue.java:619)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectio nPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 618)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:122)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.
at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF (tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdspa rser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.<i nit>(SQLServerResultSet.java:311)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ge tNextResult(SQLServerStatement.java:1526)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.doExecutePreparedStatement(SQLServerPrepared Statement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement$PrepStmtExecCmd.doExecute(SQLServerPreparedS tatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IO Buffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.e xecuteCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.executeQuery(SQLServerPreparedStatement.java :285)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecu ter.createDatasource(JRJdbcQueryExecuter.java:163)
... 93 more
