🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Column gets auto formats while rendering

Rejesh K R asked on April 12, 2019

Hi Team,
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.

3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 15, 2019

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.

Rejesh K R April 16, 2019

Hi Team,
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.

Tanya Gryshko Tanya Gryshko Flexmonster April 16, 2019

Hello, Rejesh,

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.


Please login or Register to Submit Answer