[Jaspersoft Studio as IDE for Java projects]

What I meant is can I use JSS instead of ECLIPSE with the JSS Standalone version for a simple Java desktop application.

[Complex queries with function calls shows error in Query editor dialog : Jasper 5.6.0 in Jaspersoft studio]

So should I keep the language selected as SQL or PL/SQL for complex queries which has user defined function calls, unions ,joins etc

[Jaspersoft Studio as IDE for Java projects]

Can I user Jaspersoft studio as an IDE for java projects? Or is it only meant for Jasper reports?

[Complex queries with function calls shows error in Query editor dialog : Jasper 5.6.0 in Jaspersoft studio]

I am using the latestJaspersoft 5.6.0 studio. I have reports with complex queries involving function calls joinswith + symbol etc.

So when I am putting such queries in the query editor dialog it shows errors. The Language selected is SQL. I tried setting the language as PL/SQL also. But still it gives errors. Earlier I was working with ireport 4.0 and the queries used to work fine.

Please give feedback

[How to set table row color based on JSON data value]

You can use conditional styling.

Add a new Style ,"rowStyle"  to the report

Add conditional style to the style(rowStyle) that you created now .

Give the appropriate condition for which the background color should change in the condition expression property. (For ex: $F{STATUS}.equals( "Completed" ) ). Add condition for each color required, like Status is "InProgres", "pending" etc

Now set the BackColor of this style  to the appropriate color

Now set the style "rowStyle" for the field for which the bg should change dynamically

 

[Stop repeating table/grid headers on split pages]

The height of the table should be the sum of  the height of the row and header.Go to Table and see the height of the data field(row) and the height of the header. Add this and set as the height for the table. The height of the band in which you are going to place this Table should be the same or greater(if it contains other elements) than the Table height

[Moving from Jasper 4.0 to latest version]

We have not migrated yet.. Actually we have many reports which is developed in 4.0. So are there any known issues which we should take care?

[Displaya table with Column total and row total]

I need to display he data in the following format

 

	2001	2002	2003	2004....	sum
data1	10	20	10	10	50
data2	20	20	20	20	80
data3	30	20	20	30	100
sum	60	60	50	60

My sql query is

 

select year, data1, data2,data3 from table1. Year data1,data2,data3 are allseparate columns in the table. Cross tab does not help in this case

[How to pass Multivalued Parameter to jasper reports?]

Give the  default value expression for the parameter as " java.util.Arrays.asList($P{REPORT_PARAMETERS_MAP}.get( "loc_codes" ))" and try

[textfield data is not wraped.It is displaying in wrong way]

Increase the text field width and try. Also check the text field property "Stretch with overflow" is unchecked. "Stretch with overflow" property ,if checked then will print the data which does not fit in the current line in the next line if the text field width is less.

[Moving from Jasper 4.0 to latest version]

Anyone faced any issue while migrating from Jasper 4.0 to latest version of Jasper (5.0 and above)