Jump to content
Changes to the Jaspersoft community edition download ×

Number to Monetory Conversion


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,


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