[How to overcome FATAL 1: Socket command type unknown exception in jasper soft studio?]

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)

 

[Can i create multiple categories in column or bar chart(using HTML5) without providing a query response field?]

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?

 

 

 

[How can i show values with percentage symbol, as display labels in column chart(HTML5)?]

Yes it worked.

Thank you.

[How can i show values with percentage symbol, as display labels in column chart(HTML5)?]

Yes in Tooltip i got the % symbol.

But on data labels also i need to show  values with %.

[How can i show values with percentage symbol, as display labels in column chart(HTML5)?]

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? 

[How to create multiple pairs of data in bar chart?]

Any solution?

[How to create multiple pairs of data in bar chart?]

 

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

 

[What are the major differences between Charts pro and HTML5 charts?]

Conceptual Differences 

[How to overcome FATAL 1: Socket command type unknown exception in jasper soft studio?]

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)

[How to overcome FATAL 1: Socket command type unknown exception in jasper soft studio?]

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   unknown

at 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?

 

[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 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.)

[Please explain the steps to create SparkLine Widget]

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)?

 

 

[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 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.)