anshukunal
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by anshukunal
-
-
Hi,
How to pass parameters in the sql query in the jasper report via java code.
I am attaching codes which i am using.
Code: .jrxml file<parameter name="REPORT_PARAMETERS" class="java.lang.String"/> <parameter name="REPORT_PARAMETER" class="java.lang.String"/> <queryString> <![CDATA[select * from Info_Log where $P{REPORT_PARAMETERS}=$P{REPORT_PARAMETER}]]> </queryString>This code didn't worked.Then i tried :<![CDATA[select * from Info_Log where $P!{REPORT_PARAMETERS}=$P!{REPORT_PARAMETER}]]>This gave some sql error.I am able to generate the report passing one parameter in sql query but not with 2 parameters at the same time.<![CDATA[select * from Info_Log where NAME=$P{REPORT_PARAMETER}]]> </queryString>my java code for taking parameters is:Map parameters = new HashMap(); parameters.put ("REPORT_PARAMETERS","reader"); parameters.put("REPORT_PARAMETER","reader1"); JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,parameters, connection);
-
Hi,
I am new to the jasper reports.
Need help in generating jasper report according to the input given by the user.
eg.
If I am having a table in the database having information about different people.
Now how will I create report if the user gives different input.
If user gives Name as Adam : The details of Adam should be displayed in the report.
If he gives Name as John: The details of John should be displayed in the report.
Thanks,
Anshu
-
It worked.
Thanks for your help.
-
My jrxml file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) -->
<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="Unnamed" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30">
<property name="com.jasperassistant.designer.DataSource" value="DBCompass"/>
<property name="com.jasperassistant.designer.Grid" value="true"/>
<property name="com.jasperassistant.designer.SnapToGrid" value="false"/>
<property name="com.jasperassistant.designer.GridWidth" value="12"/>
<property name="com.jasperassistant.designer.GridHeight" value="12"/>
<queryString>
<![CDATA[select * from Info_Log]]>
</queryString>
<field name="ACCESSED_URL" class="java.lang.String"/>
<detail>
<band height="452">
<elementGroup>
<textField>
<reportElement x="8" y="68" width="123" height="25"/>
<textElement/>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ACCESSED_DATE}]]></textFieldExpression>
</textField>
</elementGroup>
<staticText>
<reportElement x="161" y="8" width="162" height="23"/>
<textElement/>
<text><![CDATA[Jasper Report Demo]]></text>
</staticText>
</band>
</detail>
</jasperReport>
.java file:
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.*;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.view.JasperViewer;
public class ViewJasper {
@SuppressWarnings({ "deprecation", "unchecked" })
public static void main(String args[]){
try{
// First, load JasperDesign from XML and compile it into JasperReport
System.out.println("++++");
JasperDesign jasperDesign = JRXmlLoader.load("new_report.jrxml");
System.out.println("--------");
net.sf.jasperreports.engine.JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
Map parameters = new HashMap();
parameters.put ("Report_Title", "DEMO JASPER REPORT");
// Third, get a database connection
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("URL","Username","password");
// Fourth, create JasperPrint using fillReport() method
JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,parameters, conn);
// Or to view report in the JasperViewer
//JasperExportManager.exportReportToPdfFile(jasperPrint,"I:\\test\\jreport.pdf");
JasperViewer.viewReport(jasperPrint);
}
catch(Exception e){
System.out.println(e);
}
System.out.println("success");
}
}
Error:++++
Sep 28, 2010 4:32:13 PM org.apache.commons.digester.Digester error
SEVERE: Parse Error at line 3 column 390: Document root element "jasperReport", must match DOCTYPE root "null".
org.xml.sax.SAXParseException: Document root element "jasperReport", must match DOCTYPE root "null".
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1621)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1900)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:764)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1359)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1317)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3095)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:922)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
at org.apache.commons.digester.Digester.parse(Digester.java:1647)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214)
at net.sf.jasperreports.engine.JasperManager.loadXmlDesign(JasperManager.java:980)
at Jasper.main(Jasper.java:21)
net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException: Document root element "jasperReport", must match DOCTYPE root "null".Need help
How to pass parameters in the query
in Products
Posted