[how to solve compile time errors in jasper reports?]

only jdt-3.4.2_r894.jar is required. above listed .jar files are not necessary. i add new jasper library but not removed old jar. so please remove old jar first than add latest version of jar.

[how to solve compile time errors in jasper reports?]

Exception in thread "main" net.sf.jasperreports.engine.JRException:Errors were encountered when compiling report expressions class file:1. java.lang.Integer cannot be resolved or is not a type                value = new java.lang.Integer(1); //$JR_EXPR_ID=0$[/code]

i already added jdt jar files.

list of jdt jar files are given below.

org.eclipse.jdt.core-3.7.1

jdtcore-3.1.0

org.eclipse.jdt.core-3.11.1.v20150902-1521

jasper-compiler-jdt-5.5.9

jtds-1.3.1

jdt-0.15.0

what i am missing ?

[How to pass parameter value in the field value ?]

 

i want to do this $F{$P{subject}}.

i create general structure for .jrxml file. i pass query dynamically to the query tag like this,

    <queryString language="SQL">
        <![CDATA[$P!{Query}]]>
    </queryString>

So here Field is dyanamically changes. field can be fill by parameter ?

[problem in stored procedure ?]

this stored procedure code work on mysql terminal but it does not work on jrxml file. it gives errorDELIMITER //DROP PROCEDURE IF EXISTS try//CREATE PROCEDURE try()BEGINdeclare s_query varchar(255);    declare done bool default false;    declare c_queries cursor for           SELECT `Demo`.`Qcol` FROM ``.`QC`;    declare continue handler for not found set done = true;    open c_queries;    read_loop: loop        fetch c_queries into s_query;        if done then            leave read_loop;        end if;        -- run the query        set @sql = s_query;        prepare stmt from  @sql;        execute stmt;        deallocate prepare stmt;    end loop;END //DELIMITER ;CALL try();[/code]

this stored procedure code work on mysql terminal but it does not work on jrxml file. it gives error 

..insert your code here..net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: 123.    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:548)    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:523)    at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:404)    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: 123.    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344)    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245)    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723)    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:438)    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:550)    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)    at java.lang.Thread.run(Thread.java:745)Caused by: 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 'DELIMITER //DROP PROCEDURE IF EXISTS try//CREATE PROCEDURE try()BEGINdecla' at line 1    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)    at com.mysql.jdbc.Util.getInstance(Util.java:408)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310)    ... 6 more[/code]

help me.

[How many sub-reports can be added in jasper report ?]

i have many sub reports and i want to merge in single pdf.

[How to merge two jrxml jasper reports into a one single pdf output file ?]

I have to prepare reports using five different sql queries. Each query will give out one report table.

So I wrote 5 jrxml files each corresponding to one of the above query with their own headings, title settings, footers, pagenumbers, etc.

Now, I am able to compile, print and export each of the above jrxmls into 5 different pdfs.

However, client wants all the reports collated into one single pdf. That is in the final pdf, first four pages will be say report one, next five pages report two, then report three and so on and so forth.

1) How to achieve this ?

2) Each report has page number as 1/4, 2/4, 3/4 etc. Where the second part i.e. the complete page number is evaluated with evaluation time as report. So when I will collate all reports in single pdf (if possible), will it also be possible to re-number the pages in justification to final pdf ?

[two doctype allowed in .jrxml ?]

@ hozawa sir...

help me in this problem.

i create .jrxml file by using jaspersoft studio. In this .jrxm i fetch data [ two table ] from MySQL data. i used table element for more tables.

then i compile this jrxml file with java program and export into pdf. i use NetBeans IDE for this.

now i want to compile this file by using terminal.

i got exception " declare component element "

 

[two doctype allowed in .jrxml ?]

i know this is very poor question ?

[how to declare componentElement in .jrxml for terminal execution ?]

i create .jrxml file by using jaspersoft studio. In this .jrxm i fetch data [ two table ] from MySQL data. i used table element for more tables.

then i compile this jrxml file with java program and export into pdf. i use NetBeans IDE for this.

now i want to compile this file by using terminal.

i got exception " declare component element "

[how to create jasper report from terminal in ubuntu ?]

write jrxml code for design and java code for compilation.

for jrxml code "Doctype" is required for compilation. If you prepared jrxml code with the help of JasperSoft Studio, there is no "Doctype"

you have to add all required jar file in class path at compile time.

[How to arrange two tables in verticle manner ?]

it can be done by using table element in jaspersoft studio.

[How to arrange two tables in verticle manner ?]

i fetch two tables from database by using join query.

but both the tables are disply in horizontal manner.

i want to display both the tables in vertical manner.1(2).

[problem with casting]

THANK U

[how to solve this ?]

@reportdev.

i create java progrsm which converts jrxml file into pdf into netbeans.

i run my program with same jrxml file in netbeans IDE. my program works well.

But when i use same jasper with terminal then this problem occurse.

jrxml file work in netbeans but dont work in terminal...

 

[Document root element "jasperReport", must match DOCTYPE root "null".]

@ janak.

i got this error in terminal

 

 

[how to solve this ?]

Exception in thread "main" net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 460; Document root element "jasperReport", must match DOCTYPE root "null".
    at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243)
    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.xml.JRXmlLoader.load(JRXmlLoader.java:168)
    at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152)
    at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:115)
    at javaApplication1.main(javaApplication1.java:31)
Caused by: org.xml.sax.SAXParseException; lineNumber: 4; columnNumber: 460; Document root element "jasperReport", must match DOCTYPE root "null".
    at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
    at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:134)
    at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396)
    at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
    at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1599)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1877)
    at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:742)
    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:1290)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3132)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:852)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
    at org.apache.commons.digester.Digester.parse(Digester.java:1892)
    at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)
    ... 6 more
 

lineNumber: 4; columnNumber: 460; Document root element "jasperReport", must match DOCTYPE root "null".

There is no any document...

[Example of java program to call Jasper Report]

@ dprogrammer...

How to solve this man ?

Start ...
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/digester/Digester
    at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:115)
    at javaapplication2.javaApplication2.main(javaApplication2.java:29)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.digester.Digester
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 2 more
Java Result: 1
BUILD SUCCESSFUL (total time: 0 seconds)
 

[how to create jasper report from terminal in ubuntu ?]

i am beginner in jasper reports. HELP ME.

i create many reports from TIBCO jaspersoft studio.

i can not make jasper report from terminal.

[How to find missing field name ?]

i generat report for CSV file.

there is completime error : Field name missing. ==> JRDesignFiel@3a93b3

[net.sf.jasperreports.engine.JRException: Failed to parse the xml document. at net.sf.jasperreports.engine.util.JRXmlUtils.parse(JRXmlUtils.java:77) at net.sf.jasperreports.engine.util.JRXmlUtils.parse(JRXmlUtils.java:166) at net.sf.jasperreports.data.x]

if you are using linux ubuntu flaver , than .xml is fire this exception.

 .dbk is supported for xml data adapter..

 

 

[net.sf.jasperreports.engine.JRException: Failed to parse the xml document. at net.sf.jasperreports.engine.util.JRXmlUtils.parse(JRXmlUtils.java:77) at net.sf.jasperreports.engine.util.JRXmlUtils.parse(JRXmlUtils.java:166) at net.sf.jasperreports.data.x]

how to solve this one ?

i get this exception when i create data adapter in jasper studio ?

I am using linux ubuntu flaver.....

 

[java.lang.NullPointerException at net.sf.jasperreports.data.http.HttpDataService.getPropertyOrParameterValue(HttpDataService.java:504) at net.sf.jasperreports.data.http.HttpDataService.getUsername(HttpDataService.java:193) at net.sf.jasperreports.data.]

how to solve

java.lang.NullPointerException
    at net.sf.jasperreports.data.http.HttpDataService.getPropertyOrParameterValue(HttpDataService.java:504)
    at net.sf.jasperreports.data.http.HttpDataService.getUsername(HttpDataService.java:193)
    at net.sf.jasperreports.data.http.HttpDataService.setAuthentication(HttpDataService.java:177)
    at com.jaspersoft.studio.data.adapter.JSSBuiltinDataFileServiceFactory$1.createHttpClient(JSSBuiltinDataFileServiceFactory.java:62)
    at net.sf.jasperreports.data.http.HttpDataService.getDataFileConnection(HttpDataService.java:150)
    at net.sf.jasperreports.data.DataFileUtils.createConnection(DataFileUtils.java:72)
    at net.sf.jasperreports.data.DataFileUtils.getDataStream(DataFileUtils.java:78)
    at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:152)
    at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:82)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
    at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
    at java.lang.Thread.run(Thread.java:745)

?