Formatting numeric value as Dimension

Hello,

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 ?

Thanks,

Detlef