I have a numeric value inside my DB table that I would like to use in a Jasper Server domain.
I would like to change the number format of the dimension 'col1' using no grouping separator. But in the context menu of a dimension there is no formatting option.
The postgres table looks like:
The domain should hold all three columns.
'name' and 'col1' should be dimension, 'col2' should be 'measure'
Something like this:
How can I cange the format of 'col1' showing only Integer value without fraction and without grouping separator ?