caps_lock9

Maybe you need use $X{par1, par2, par3} or maybe problem with date? to_date('03/31/2015','DD.MM.YYYY')? If you found answer, please write about it.

Good day. Could you help me please? I try to write report for JasperReport. Report with charts. But my reports isn’t working with MAIN DATASET, it’s working only with SUB DATASET. This problem is important for me, because I need use parameters. Use parameters with sub dataSet is second problem for me. (maybe you can give me link with explanations?) I use iReport 5.6.0, TIBCO JasperSoft Studio 6.0.3, Jasper Server 6.0.1 For earlier Thank you very much. This code (working only number 1 (sub dataset), number 2 isn’t working): <?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="chart" language="groovy" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="685d5c60-f947-4765-ba91-b0ea7c7ce771"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><subDataset name="dateSet1" uuid="34dce292-9dd8-4008-b5ea-858a7abf263c"><queryString language="SQL"><![CDATA[select e."type", count(*)from MON_FUNC.V_EVENTS Ewhere e."type" is not nullgroup by e."type"]]></queryString><field name="type" class="java.lang.String"/><field name="COUNT(*)" class="java.math.BigDecimal"/></subDataset><queryString><![CDATA[select e."type", count(*) as countfrom MON_FUNC.V_EVENTS Ewhere e."type" is not nullgroup by e."type"]]></queryString><field name="type" class="java.lang.String"/><field name="COUNT" class="java.math.BigDecimal"/><background><band splitType="Stretch"/></background><title><band height="32" splitType="Stretch"><staticText><reportElement x="61" y="0" width="100" height="32" uuid="8ac52162-9ad4-427b-a63d-9cf14750a3e3"/><textElement><font fontName="Arial" size="24"/></textElement><text><![CDATA[#1]]></text></staticText><staticText><reportElement x="380" y="0" width="100" height="32" uuid="efe31290-567d-43ed-9e67-4f794d24823f"/><textElement><font fontName="Arial" size="24"/></textElement><text><![CDATA[#2]]></text></staticText></band></title><pageHeader><band height="131" splitType="Stretch"><pieChart><chart><reportElement x="0" y="0" width="204" height="131" uuid="d5e7b798-8032-4eba-bc9c-a658aafcdfa5"/><chartTitle/><chartSubtitle/><chartLegend/></chart><pieDataset><dataset><datasetRun subDataset="dateSet1" uuid="9f9177d0-68bd-4882-8a2f-adda6595b67e"/></dataset><keyExpression><![CDATA[$F{type}]]></keyExpression><valueExpression><![CDATA[$F{COUNT(*)}]]></valueExpression></pieDataset><piePlot><plot/><itemLabel/></piePlot></pieChart><pieChart><chart><reportElement x="351" y="0" width="204" height="131" uuid="c072e23e-3e5d-4d9d-8bbe-a3c11701e5a0"/><chartTitle/><chartSubtitle/><chartLegend/></chart><pieDataset><keyExpression><![CDATA[$F{type}]]></keyExpression><valueExpression><![CDATA[$F{COUNT}]]></valueExpression></pieDataset><piePlot><plot/><itemLabel/></piePlot></pieChart></band></pageHeader></jasperReport>

See: http://community.jaspersoft.com/questions/534053/jdbc-and-oracledriver-problem maybe it's help you

My problem: net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:172)at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:127)at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:157)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverat org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)at java.lang.ClassLoader.loadClass(Unknown Source)at java.lang.Class.forName0(Native Method)at java.lang.Class.forName(Unknown Source)at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174)at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:144)... 4 more My solution: I download from this site (oracle): http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html driver for oracle 12 and I write in Data adapter wizard (on tab Draver Classpath, path for my download file)