Jump to content
Changes to the Jaspersoft community edition download ×

Number to Monetory Conversion


sonal

Recommended Posts

Hi all,

I have a column in the table dragon_policy which contains a number type datatype Policy_premium.

 

I am to extract value in the monetory form.

 

Example -

 

Values stored inn database - 1520

 

I am Required - $1520

 

Thanks and Regards,

Ram

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

You wish to display a numeric value on a report as currency?

 

Select the field in iReport, then look at 'Pattern' in 'Element Properties' in the right-hand pane. Change it to 'currency' and make sure it is 2 decimal places.

Link to comment
Share on other sites

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...