[Single select Query control]

use below syntax

1. $P{parameter name} - This will be like ? in JDBC Prepared Stmt

2. $P!{parameter name} - This will just replace the text in the query, so u could use a part of sql query in it.

3. $X{IN/NOT IN, field, parameter name}

 

See tutorials and docs in this community.

[java.lang.StackOverflowError]

Even i get the same stackoverflow error, only on one of our prod server. There is a bug logged in the tracker for this. I suggest u to add ur info there.

 

I found that for some reason when subreport doesn't fill in the remaining page and has to overflow, there is this error thrown, may be due to a deeply iterative logic. BUT it doesn't happen in one of our server, i have no reason for it. For now increasing your stack memory will be one option, but not a solution.

 

I prefer using javaflow over thread, to avoid creating multiple threads.

 

http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4855

[Unknown hyperlink target 0]

need more details, are the subreports accessible from the server. what is the subreport expression. more error comments and sample template will be helpful.

[How to Import a Image from Database]

try using the the sql Blob's getBytes(long pos, int length) method to get the byte[]

[Provide Link in Report]

You can use the hyperlinks functionality, where text fields, images and chart elements are the only ones supporting it. Specify the hyperlink of type 'External Reference' and provide the URL as hyperlinkReferenceExpression. I think PDF do support this as a link and open the page in a new window.

[put a file into report]

U can use a custom datasource and fill in the contents. Examples are in the dist.

Post Edited by rmukkamalla at 07/29/2010 18:22

[Jasper String Display Issue]

Hi,

 

I had noticed that, whenever a subreport isn't able to fit in the same page of the main report, it does throw this exception. But sometimes i donot see this happening.

I'am not exactly sure why, this happens. We are using two production servers, and this happens randomly on one of them. So I think my server resources are good, will investigate further.

 

Thanks

Ram

[java.lang.StackOverflowError]

It is at

 

http://sourceforge.net/tracker/?func=detail&aid=3025649&group_id=36382&atid=1121504

[JRXML Condition if]

Use 'Print When Expression' property of the image element, of type java Boolean

[java.lang.StackOverflowError]

Thank You, for reply.

Added bug in sourceforge ID: 3025649.

 

Hope this will be solved soon.

[Report filling thread was interrupted]

I notice these exception, only once in a while. The filling thread seems to be getting interrupted.

Using JasperReports 3.7.2, running from Java Service Wrapper, called from Tomcat. Using JVM 1.6

Any suggestions to overcome this issue.

[iNFO] 2010.07.02 11.46.57.738 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: GetReportStatusLR UID:bba4a909-43da-4928-9876-4a76da16c701
[iNFO] 2010.07.02 11.46.57.864 | {com.dataart.spiral.services.handlers.report.GetReportStatusLRH} Request done: 126ms
[iNFO] 2010.07.02 11.46.58.447 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} %% Exception in Report Execution:net.sf.jasperreports.engine.JRException:
The report filling thread was interrupted.
 net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 62]
 net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42]
 com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43]
 com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274]
 sun.reflect.GeneratedMethodAccessor39#invoke[l: -1]
 sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25]
 java.lang.reflect.Method#invoke[l: 597]
 sun.rmi.server.UnicastServerRef#dispatch[l: 305]
 sun.rmi.transport.Transport$1#run[l: 159]
 java.security.AccessController#doPrivileged[l: -2]
 sun.rmi.transport.Transport#serviceCall[l: 155]
 sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649]
 java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886]
 java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908]
 java.lang.Thread#run[l: 619]
cause:net.sf.jasperreports.engine.fill.JRFillInterruptedException:
null
 net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 405]
 net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 378]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillBackground[l: 1802]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReportStart[l: 259]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReport[l: 127]
 net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 938]
 net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 841]
 net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 58]
 net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42]
 com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43]
 com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274]
 sun.reflect.GeneratedMethodAccessor39#invoke[l: -1]
 sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25]
 java.lang.reflect.Method#invoke[l: 597]
 sun.rmi.server.UnicastServerRef#dispatch[l: 305]
 sun.rmi.transport.Transport$1#run[l: 159]
 java.security.AccessController#doPrivileged[l: -2]
 sun.rmi.transport.Transport#serviceCall[l: 155]
 sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649]
 java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886]
 java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908]
 java.lang.Thread#run[l: 619]

[iNFO] 2010.07.02 11.46.58.447 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Exception in Report to String:net.sf.jasperreports.engine.JRException: The report filling thread was interrupted.
[iNFO] 2010.07.02 11.46.58.448 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Request done: 1198ms
[iNFO] 2010.07.02 11.46.58.450 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: CUDReportStatusLR UID:null
[iNFO] 2010.07.02 11.46.58.454 | {com.dataart.spiral.services.handlers.report.CUDReportStatusLRH} Transaction commit: 1+3ms

 

Thanks

Ram
 

[java.lang.StackOverflowError]

I'am noticing this StackOverflow Error once in a while. Unable to know the real cause. It is getting hard to replicate as well. I'am using JasperReports Javaflow 3.7.2, in a Java Service Wrapper, called from Tomcat.

Any help will be appreciated. Attached is the report template and its subreport. Also attached is a sample pdf report.

Exception is thrown at :

jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, session.connection()); // Hibernate Session is used.

I'am using 3 subreports, where one of it has an expression of the form

($P{boolean_includePointsColumn}.booleanValue()?new File($P{path} + "TranscriptWithPicture_SubReport.jasper"):new File($P{path} + "TranscriptWithPicture_NoPoints_SubReport.jasper"))

 

[iNFO] 2010.07.02 11.11.50.817 | {com.dataart.spiral.middleware.MiddlewareImpl} LR: GenerateReportLR UID:null
[iNFO] 2010.07.02 11.11.51.053 | {com.dataart.spiral.services.handlers.report.GenerateReportLRH} Exception: net.sf.jasperreports.engine.JRRuntimeException:
java.lang.StackOverflowError
 net.sf.jasperreports.engine.fill.JRFillSubreport#prepare[l: 710]
 net.sf.jasperreports.engine.fill.JRFillElementContainer#prepareElements[l: 329]
 net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 419]
 net.sf.jasperreports.engine.fill.JRFillBand#fill[l: 378]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillColumnBand[l: 2018]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillDetail[l: 757]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReportStart[l: 269]
 net.sf.jasperreports.engine.fill.JRVerticalFiller#fillReport[l: 127]
 net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 938]
 net.sf.jasperreports.engine.fill.JRBaseFiller#fill[l: 841]
 net.sf.jasperreports.engine.fill.JRFiller#fillReport[l: 58]
 net.sf.jasperreports.engine.JasperFillManager#fillReport[l: 417]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 169]
 com.dataart.spiral.services.handlers.report.GenerateReportLRH#handleRequest[l: 42]
 com.dataart.spiral.services.lrc.HibernateLiteweightHandler#handleRequest[l: 43]
 com.dataart.spiral.middleware.MiddlewareImpl#processRequest[l: 274]
 sun.reflect.GeneratedMethodAccessor39#invoke[l: -1]
 sun.reflect.DelegatingMethodAccessorImpl#invoke[l: 25]
 java.lang.reflect.Method#invoke[l: 597]
 sun.rmi.server.UnicastServerRef#dispatch[l: 305]
 sun.rmi.transport.Transport$1#run[l: 159]
 java.security.AccessController#doPrivileged[l: -2]
 sun.rmi.transport.Transport#serviceCall[l: 155]
 sun.rmi.transport.tcp.TCPTransport#handleMessages[l: 535]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run0[l: 790]
 sun.rmi.transport.tcp.TCPTransport$ConnectionHandler#run[l: 649]
 java.util.concurrent.ThreadPoolExecutor$Worker#runTask[l: 886]
 java.util.concurrent.ThreadPoolExecutor$Worker#run[l: 908]
 java.lang.Thread#run[l: 619]
cause:java.lang.StackOverflowError:
null
 java.util.HashMap$Entry#hashCode[l: 720]
 java.util.AbstractMap#hashCode[l: 461]
 java.util.HashMap$Entry#hashCode[l: 720]
 java.util.AbstractMap#hashCode[l: 461]
 java.util.HashMap$Entry#hashCode[l: 720]

   NOTE: THIS ABOVE HashMap LINE REPEATS AROUND SEVERAL HUNDREDS OF LINES
 

[can we print no records found]

At the report level, set this attribute, whenNoDataType="NoDataSection"

Include ur text fields and any others in the "No Data Section" band.

[having variable length fields]

set "Stretch with Overflow" property to true. It will make the text field stretch vertically when the contents donot fit the element. Also make sure if there are any elements below this textfield, to make position type as 'float'. So that element below will move down relative to above elements.

[is jrxml a programming language?]

jrxml is just an xml standard definition to represent a Reporting Template. U compile this template file using jaspereports API and fill it with data to generate a report.

[having different reports combined in one report]

see batch exporting sample in /demo/samples/batchexport. U can export a list of Jasper Print object into a single report.

[dynamic reports - new in jasper]

if u need dynamic reports, with report template changing, like filter of columns and others, see http://dynamicjasper.sourceforge.net/.

 

that api runs on jasperreports. It is possible to do this directly using JasperReports, but u will be writing too much of code and i don't like that approach myself.

[installation advice]

that db connection in IReports is just to test Report Templates and see how they look, I don't think it will help u in any other way. It supports several data sources.

Why not use JDBC or any others.

I personally donot recommend ODBC due to several limitations of its own.

[Parameters in where clause]

It is possible and I had used to successfully in far more complicated case. Available syntax for such filters are $P{}, $P!{} and $X{}.

 

$P{} - It is like the java.sql.PreparedStatement parameters, make sure the parameters are of the correct type.

like - SELECT b.id, b.name FROM branch b WHERE b.id = $P{branchID}

$P!{} - It can replace the texts within the SQL. U can provide a part of the

Query. The query executed will first replace these parts of the query and then apply the parameters $P{}.

$X{} - They are used for IN/NOT IN type queries.

 

Do provide the bug u are having / specific question, can assist u further.

 

Ram

 

[installation advice]

IReports is a report designer, that is all u need to create Report Templates. I doubt u can have end users create their own reports, unless they are aware of this tool, reporting template structure, about the datasources u use, font extensions and so on. This is for a Report Developer not an actual End User.

 

JasperReports is an API for generating reports using the templates created using the above tool.

 

JasperServer is an enterprise BI application running on several servers. It is the one u are looking for, if u want End Users to create their own reports (charts/crosstabs/tables), schedule reports, drill down reporting and more.

[Page Header don`t appear in summary]

The summary is the last band of the report and appears at the end of the report. It doesnot show the Page Header and Footer. See the format of the JRXML report template.

 

Not sure if 'Last Page Footer' is of any help to u.

[XML DataSource namespace aware]

Just wondering if the XML Data Source in the latest release is namespace aware.

I have a requirement where I have to process data in xml, and wondering if the xml should be as simple as the one in examples

/demo/xmldatasource/northwind.xml file of jasper distribution.

Thanks

Ram

[PDF Font not match]

can u give the sample jrxml element

[Trouble showing Chinese data in PDF files]

Just wanted to leave a note for others, who might have same issues -

I had solved this using Spring based Font Extensions support in JR 3.5, and used Arial Unicode Font to support many languages, using the same report template.

[How to stop null from showing up on the report]

when u are using all parameters in the same text field element, i don't think u have any other option. blankWhenNull works when the field itself returns null.

Other option is to use duplicate parameters, one to hold values and other to check for null and give an appropriate value.