Lorina

I found it as a space sensiitive issue. While providing query in Dataset window of jaspersoft studio ,we need to maintain proper(uniform) spaces at the end of each line. (not sure about the exact space giving format)

I want to create three(3) categories with multiple(2) series values. But for the category field, i want to provide three(3) categories manually, instead of using a query response field as a value to the category expression field (using HTML5 bar and column charts). Let me confirm whether it is possible to provide three category values without using a Query response field?

Yes it worked. Thank you.

Yes in Tooltip i got the % symbol. But on data labels also i need to show values with %.

As i have to choose an integer data type in measure value field , in display value label it is also coming as same style. (I used plotOptions.series.dataLabels.enabled for showing labels ,which takes data from measure value field) I can't append a '%' symbol as it is an integer data type.(I can't use String data type as it may disturb the calculation) Is there any methods or formats which will show % value?

Any solution?

I need to prepare below bar chart(in HTML5) with multi pair of values. How can i configure below chart data (country name in y-axis,for each country need to set Total orders and Average Frieght values) in confurigation? Here i want to set the Country names manually, not as a Query response Field. Give me the correct format of data representation in Categories level,Series Level and Measures. http://community-static.jaspersoft.com/Resources/Images/initial-bar-chart_321x218.png

Conceptual Differences

Yes,it has been already added. In Jasper server(6.0) report is running fine.But getting this exception in jaspersoftstudio only.Can't able to find the cause. (using jasper soft studio 5.6.0)

Hello, I am new to jasper soft studio. I tried to execute one query in a dataset. But i am getting an error: Caused by: org.netezza.error.NzSQLException: FATAL 1: Socket command type unknownat org.netezza.internal.QueryExecutor.getNextResult(QueryExecutor.java:273)at org.netezza.internal.QueryExecutor.execute(QueryExecutor.java:73)at org.netezza.sql.NzConnection.execute(NzConnection.java:2597)at org.netezza.sql.NzStatement._execute(NzStatement.java:841)at org.netezza.sql.NzPreparedStatament.executeQuery(NzPreparedStatament.java:161)at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) *Database Connection is fine. But the same query is working fine in Netezza database workbench.What'll be the solution?

For example, how can i create the spark line for four values Cisco,Google,Microsoft,Oracle having different data ranges? (This example is the sample view, in the design part of jaspersoftstudio Professional(5.6.0) while using sparkline report component from widgets pro. Please refer Jaspersoftstudio Professional(5.6.0)->widgets pro->sparkline for complete understanding as it is difficult to mention here clearly.)

How can i create multiple spark lines in a single sparkline component in Jaspersoftstudio Professional(5.6.0)? For example, how can i create the spark line for four values Cisco,Google,Microsoft,Oracle? (Please refer Jaspersoftstudio Professional(5.6.0)->widgets pro->sparkline for complete understanding as it is difficult to mention here clearly. This example is the sample view, in the design part of jaspersoftstudio Professional(5.6.0) while using sparkline report component from widgets pro)?

For example, how can i create the spark line for four values Cisco,Google,Microsoft,Oracle having different data ranges? (This example is the sample view, in the design part of jaspersoftstudio Professional(5.6.0) while using sparkline report component from widgets pro. Please refer Jaspersoftstudio Professional(5.6.0)->widgets pro->sparkline for complete understanding as it is difficult to mention here clearly.)