I am using a flat form report in which the column automatically formats as Integer based on the first value. I have both Integer and string values in the column. Even though the json value is of string format, the value takes as a integer.
Please find the sample screenshot in the attachment(First 7 seven value is Integer, remaining all are string).
Please check an do the needful.
Thank you for posting your question here.
In case you need to define the data types explicitly please refer to our docs for more information: https://www.flexmonster.com/doc/data-types-in-json/. There is an example of how to define the data types explicitly in the meta object.
Also, please make sure that your JSON is defined correctly. Here is the example of the supported JSON formats: https://www.flexmonster.com/doc/json-data-source/.
Please let us know in case of any other question.
The datatype of the json data object already in string. The column contains both string and integer. So if the first value is integer then the column automatically formats the as integer. But in case if the first value is of string,then the column takes both string and integer.
Kindly check and do the needful asap.
Thanks for an update.
We have checked on our side and everything seems to be working as expected: https://jsfiddle.net/flexmonster/aepvpc6e/159/. Here you can see that the first value of
Sale Qty is an integer. However, it is formatted as a string.
If this sample doesn’t solve the issue, we kindly ask you to modify the sample so that the issue is reproducible. This would greatly help us.