[crosstab in detail band]

So you should using subreport to accomplish this effective

[new line character]

hi,

As your text field's height is big enough you can use

this style to accomplish this effective

"good"+"(backslash)n"+"morning"

 

the attachment is a sample.

 

hope to help you!

 

cheng.ken [file name=new_line_character.jrxml size=3263]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/new_line_character.jrxml[/file]

 

Post edited by: Cheng.Ken, at: 2007/07/16 10:13

Post edited by: Cheng.Ken, at: 2007/07/16 10:14

[flash Tutorials from talend.com]

Dear all,

http://www.talend.com/tos/tutorials/menu.php is the

tutorials from talend.com

 

 

hope to help you all!

 

Make progress together!

 

cheng.ken

[JasperServer 2.0 feedback]

Deploy jasperserver in a cluster environment error:

 

 

java.lang.IllegalArgumentException: Attribute [com.tonbeller.wcf.controller.RequestContextFactory] is not serializable

 

it's seems that that some property not implement

serializable

 

 

cluster environment:

2 tomcat v5.5.20

jdk5

two cluster machine share the same database

 

 

others:

run anyone tomcat of the cluster there is no error.

[Error when cluster jasperserver (v1.2.1)]

Dear all,

Did you all have the experience of the cluster jasperserver v1.2.1? When we cluster it we get the following error

 

 

Deploy jasperserver in a cluster environment error:

 

 

java.lang.IllegalArgumentException: Attribute [com.tonbeller.wcf.controller.RequestContextFactory] is not serializable

 

it's seems that that some property not implement

serializable

 

 

cluster environment:

2 tomcat v5.5.20

jdk5

two cluster machine share the same database

 

 

others:

run anyone tomcat of the cluster separately there is no error.

 

the attachment is the detail error message

 

Thank you anyway!

 

Post edited by: Cheng.Ken, at: 2007/07/16 07:18 [file name=error.html size=4155]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/error.html[/file]

Post edited by: Cheng.Ken, at: 2007/07/16 07:51

[crosstab in detail band]

error incrementing crosstab dataset

 

This is a common error when generate a corsstab report. you should not place the corsstab in the detail secion,

you should place it in the summary section

 

hope to help you!

[search for .jrxml object on the jasper server?]

hi,

The .jrxml and other resource file reside in the database. when you installed jasperserver and there is a

database named jasperserver in the assigned the database server.

you will find that all the jasperserver configure file reside in the this database.

 

hope help you

[Condition on text field color]

hi,

I upload a sample file. if you want to use a conditon-style for some text filed. please make sure to clear the "fore-color" or "back color" otherwise you may not get the result.

 

 

hope to help you! [file name=condition_style_sample.jrxml size=8177]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/condition_style_sample.jrxml[/file]

[Condition on text field color]

hi,

please refer http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=20716#20716

it may be help you!

[No background color visible in xls or html report]

Hi,

Please upload your .jrxml file may be I can help you.

[Styled Text does not work in 2.0]

so sorry to response so lately. I have upload a sample you can refer it.

 

in order to make this report work you should use the foodmart(the sample data of the jasper analysis) as the backend data [file name=AllFeatures.jrxml size=8589]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/AllFeatures.jrxml[/file]

[hadling variables with groups and conditions]

Why not create a group using the "status field". As the need of your is the born to group.

 

Wish help you!

[report growing columnwise and rowwise]

This is corsstab report. It's supported by jasperreport now.there is a sample in the ireport manual.

[Header and Footer in all pages for crosstab report]

Thank you! It's a good method.

1:create a dummy group

2:put your corsstab in the footer of the dummy

3:put your title at the header of the report

4:put your title at the footer of the report

[jasperserver don't synchronize report with ireport]

Dear all,

When I modify the report through jasperserver plugin in ireport then use the "refresh content" function to synchronize the report with jasperserver. but the report in the jasperserver is unchanged!

 

Thank you anyway!

 

Cheng.ken

[Apply Styles Globaly]

As far as i know we can set the default report style(font,color,backcolor,forecolor)...etc.

in other words if you have set the default style then all the report element will apply it when you don't change it.

 

you can achieve this by the styles library of ireport

 

good luck

 

Cheng.kenB)

[Required Files for Using JasperReports]

Generally speaking you should not download other package.The JasperServer shipped with all the required the jar.

[ireport and jasperserver plugin]

I have the same problem with you! The reason is the classpath.below is the error message:

 

java.lang.Exception: 1 - net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Only a type can be imported. it.businesslogic.ireport.IReportScriptlet resolves to a package import it.businesslogic.ireport.IReportScriptlet; <---------------------------------------> 1 errors at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:73) at java.lang.Thread.run(Unknown Source)

 

 

:sick: solution:

 

You just need to put the ireport.jar to the %jasperserver_home%/WEB-INF/lib

 

good luck!

 

Also you can refer http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=12474#12474

Post edited by: Cheng.Ken, at: 2007/06/26 08:22

[Group by Month]

SELECT ProductName, Product_Id, DeliveryDate, SUM(Quantity), UnitPrice FROM customer_order GROUP BY Product_Id, Month(DeliveryDate) ORDER BY DeliveryDate;

 

 

in fact your sql syntax can not compile. a correct one is like this

Code:

SELECT 
ProductName, 
Product_Id, 
DeliveryDate, 
SUM(Quantity), 
UnitPrice 
FROM 
customer_order 
GROUP BY ProductName, 
Product_Id, DeliveryDate, UnitPrice 
ORDER BY DeliveryDate;

you can adjust your sql as need like above

Hope to help you.

Post edited by: Cheng.Ken, at: 2007/06/26 01:06

[print when condition for a variable]

Please notice the error message:

 

The operator > is undefined for the argument type(s) java.math.BigDecimal,

 

you can use compareTo(BigDecimal val) to implement this function

[Styled Text does not work in 2.0]

Dear,

Make sure you have done the following things:

 

1: Checked the "is styled text" of the text

 

2: Make sure you have use the correct tag. the <style></style> is case-sensitive. you can refer the document http://www.jasperforge.org/images/documentation/jasperreports/samples/StyledTextReport.html

 

good luck

[Could not load the following font]

Dear,

you can do the following steps to solve your problem:

1: download the iTextAsian.jar and iTextAsianCmaps.jar from the http://www.lowagie.com/iText/download.html. these two packages support the asian font. By default ireport does not include them

2: copy the downloaded two jars into lib folder of your ireport

3: set the correct pdf font name and pdf encoding name for your text

Post edited by: Cheng.Ken, at: 2007/06/25 04:56

[There is no jasperserver plugin in ireport2?]

I have knew it.

in fact the jasperserver plugin is not transfered with

ireport. you can download it from

 

http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243&release_id=483124

 

and the howto.txt will instruct you how to do it!

 

good mood !

[internationalize static text]

Dear all,

I can use "$R{}" to internationalize my "text field"

but I can not internationalize the "static text" .

why? thank you anyway!

[internationalize static text]

Dear all,

I can use "$R{}" to internationalize my "text field"

but I can not internationalize the "static text" .

why? thank you anyway!