Jump to content

Formatting numeric value as Dimension


detlef.brendle

Recommended Posts

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:

converted-file.png.a764b0e08bf8d32b18562dd44673d455.png

The domain should hold all three columns.

'name' and 'col1' should be dimension, 'col2' should be 'measure'

 

Something like this:

converted-file.png.9cfbd752da34c8d645012d4584edccb8.png

How can I cange the format of 'col1' showing only Integer value without fraction and without grouping separator ?

 

Thanks,

Detlef

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...