dohungnd94

What I mean when I said that u should check your SQL query because I saw u used 2 column in your page, but your detail still duplicated in two column. You can use " select distinct " in your SQL query, or use " Order by City" , may be it can fix your problem.

Check your static text and text field, find the elements which are overlaped and adjust their size, I had faced this problem and it was so annoy. My advance is keeping your patience ^^

At your field text, click right mouse and choose "Field Pattern", then choose your format, u can set the pattern is "#,##0" to display that u want.

It's so easy. The maximum height of a band is the height of your page, so if your title band too long, u can set it in a page by check "Title on new page" of your report properties. Cheers!

In my opinion, I think your problem about your SQL query. U can display your report based on your query

The video you post was not clear. You can see more in : Moreover, you can download Jasper Reports Ultimate Guide to read Crosstab in it. It's so clear and easy to understand and practice.

You can use CAST ( your_date as DATE) to convert your_date to DATE format. Then, in a field, you can write : $F{closed_date} - $F{open_date}. It will display the day difference between. Hope it works well, cheers ^^

You must check carefully your SQL query, if you do not want the duplications happen, you can select distinct.

The exact solution u need is using Crosstab, hope u can find the way to solve your solution, cheers!

Hi, this is solution I searched, may be useful for u : Resolution:You should register the Japanese font that you are using as a font extension. To create a font jar, take the following steps: Open iReportGot to Tools->OptionsUnder the iReport section, find the Fonts tab (Not the Fonts and Colors section)Click on "Install Font"Select the main TTF file for your font and click NextSelect the related italic, bold, and bold italic font files and click Next..Next...FinishSelect the Font and click "Export as extension"Put in your application classpath. To do this just copy the jar to the /WEB-INF/lib/ folder, restart the server and then try to use it for reports.

Hi, u can read carefully the article from the following link to detect your problem: http://community.jaspersoft.com/documentation/jasperreports-server-user-guide/running-job-repeatedly Hope it's useful for u, cheers!

The problem may be your current band cannot display full the records. Set your current group is float and check Stretch with overflow. Cheers