Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view
I have a query on a myqsl server returning a columns with numbers and nulls.

I define a DataSet on the KA server.
When I link the DataSet in RportDesigner, the column is created as String.
The null values, are real string containg characters "null".

Testing in javascript:
if( myValue == null )
is evaluated as false.

if( myValue == "null" )
is evaluated as true

if I cast this column to Number in the report, the conversion from "null" to BigBecimal fails.

Where can I define the correct datatypes on the server DataSet ?

I can't create a simple report and I can't belive this.
Environment KnowAge server 6.2.0 - KA report designer 6.2.0
in Reporting by (170 points)

Please log in or register to answer this question.

...