[Open a PDF.]

 JR doesnt do what you need. It is a reporting tool.

However, you can use itext (JR has it) or someother library to do that.

There are lots of examples.

[Collection of strings]

lets say, you have two fields, one for label (fixed length/height), the other one is actual data.

put them in a frame, use "strecth with overflow" with data field.

then for the label field, for stretch option, select "tallest object in the band".

(altough it says band, it actually gets the tallest object in the frame, which is the container)

also, if you have other elements below them, you need to make their position type as "float"

[Subversion access]

 anonymous:anonymous

[sourcecode : trunk vs tags/jr<version>]

trunk doesnt include some changes made in 4.0.2 version. (JRParagraph interface and related changed)

is that normal?

I was updating JR version, since I saw couples bugs fixed in SVN (introduced in 4.0.2 version), I used "trunk" codes.

Is it possible to get the latest code, somewhere ? :)

 

Post Edited by ceday at 07/11/2011 13:56

[String concatenation involving whitespaces]

net.sf.jasperreports.text.truncate.at.char=true

this is the only setting you should change for what you need. it works fine for me.

[Change background color when repeating columns]

 -Use scriptlet 

-Declare a variable and assign its value with each record. Compare the data with the variable (which is previous one)

But your data should be sorted.

[JBoss Apcation Server]

exclude servlet.jar if you have.

you should have the exact class name somewhere in log files.

 

 

[Is the JasperReport object thread-safe?]

afaik, yes. ( they are cached in my app)

[Report in Text Format]

try something like this,

exporter.setParameter(JRTextExporterParameter.CHARACTER_HEIGHT, new Float("14"));

and set height to 14 pixel in jrxml for detail/group band elements.

 

 

 

 

[[Solved] 1 Data Source & several sub reports]

If you are absolutely sure, you cant handle subreports in a single subreport using some expressions and groups, you might try this one. I am not exactly sure it will work, but it should :)

If you havent changed PrintOrder property of the report, default one should be Vertical.

Between two subreports, you need to call "ResultSet.beforeFirst()", however resultset should be rewindable to do this.

You might need to write a scriptlet.

Or you can write a cutom JRDataSet and always call beforeFirst method on the constructor.

 

 

 

Post Edited by ceday at 01/18/2011 11:09

[No query executer factory registered error]

if you are using jar files as extracted in application server environment by any chance, you might get this error since there are two "jasperreports_extension.properties" files (in JR jar and JR font jar) and one of them will be overrided since they would be in same path.  

[Database connection Issues]

 option one: send different connections as a parameter and use them as connection expression.

$P{REPORT_PARAMETERS_MAP}.get("CONNECTION-A")

option two: impelementing custom JRQueryExecuters.

there could be other ways to do this, these are the first ones I can think of.

afaik JR doesnt manage your db connections in any way, so be sure to close/ or return them to pool(if you have a pool impelementation) when you are done with them.

Post Edited by ceday at 01/13/2011 14:57

[JasperReports too slow]

have you tried using JaxenXPathExecuterFactory?

I have seen somewhere (probably here in forums), this implementation is a lot faster than the default one.

override the property in jasperreports.properties file

net.sf.jasperreports.xpath.executer.factory=net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory

[Problem in Generating a PDF having 200 columns]

 -why do want to export such a report in pdf?

-do you have actually a jrxml file or are you using some other utilies (dynamicjasper etc.) to build your report at runtime?

I am not really sure, but JR might be doing some truncation if your data doesnt fit the template.

 

[[Solved] 1 Data Source & several sub reports]

if you actually pass the same resultset to each subreport; while first one processing it, it will consume all the records.

As a result, the second one will have no record.

 

[Working with Dates Expressions]

 use Date.compareTo method to be safe.

[[Solved] Aggregation SUM with conditon]

 sum expression for COMMISSIONA=> $F{TYPE}.equals("A") ? $F{COMMISSION} : new BigDecimal(0)

[JRBeanCollectionDataSource Error retrieving field value from bean]

 afaik, fields must be case-sensitive, since it uses reflection to get field values.

check that one.

[[Solved] Collections, master report & sub reports]

 in subreport properties, there is parameters&return values. (there is an example: demo/samples/subreport)

you can use that one, or there is another one called parameters map expression (for bulk)

(recommended usage is for this one is new HashMap(${Map_exp}) If you want to pass all masterreport params to subreport.

 

 

[Columns in Report]

In report properties, there is Columns property.

It is what you are looking for.

 

[Comparing BigDecimal values, help!!]

probably this is whats wrong:

new BigDecimal($F{document}).compareTo(new BigDecimal(1))=new BigDecimal(1)

should be

new BigDecimal($F{document}).compareTo(new BigDecimal(1))==1 ? ..

there is another similar expression, you should change that one too..

 

 

 

[JasperReports vs. BIRT]

 I have used JR some time ago :) 0.5x beta- 1.x

Actually it was quite good back then too :) 

Recently I have begun to search an updated java-based report engine to replace the reporting engine for the company I have been working sometime.

Most obvious ones were of course BIRT and JR.

BIRT has an advantage of being eclipse-based community but I think it is still immature and need some time.

There was not enough components when you compare with JR (complex components actually is not problem, they are considred as facility, but I couldnt actually see "line" component in BIRT which might be a critical one for some) (maybe it has now, dont know)

And I didnt really like the GUI design, grid-layout was only option or I just didnt know how to do otherwise.

(actually I would be a good future to be able to use grid-layout for some bands - not the whole report- in JR)

I think what missing in JR is an eclipse plugin, which they seem to be working on. ireport is a good one, but eclipse integration is a must for such a report engine.

 

 

 

[Help-Subreport not working]

is there a rule that subreport is supposed to fit the page?

I am getting the same stackoverflow exception, if the subreport doesnt fit.

[How to compile source codes?]

Is there any documentation for how to build sources in Netbeans?

I am a long-time eclipse user and I feel completely "dummy" when I just open Netbeans IDE :)

There is supposed to be one in Wiki but it shows only how to design a report in Netbeans, not the compilation stuff.

 

 

 

[is there a better way to pass reportParams to customDB without actually sending as a parameter?]

 I havent tried it but I think i might have found a better solution.

MyDBSource is not an actually query datasource, however query executer factory classes have report parameters.

So implementing datasource provider and a factory would solve the problem.

And we could use  XXX (parameter) as the query.

Ant other idead ? :)