CODEWITHSUNDEEP
crystal-reports
vissubabu
vissubabu

Reputation: 519

removing decimals in crystal reports for number field

I have a field year which is string type coming from db side.So I converted that to number and adding 1 more year to that to show like this:

 Year:2014-2015

Below is the formula.

'Year' & ':' & tonumber({FocusOnCustomer.YEAR})&'-'&(tonumber({FocusOnCustomer.YEAR})+1)

Everything is working fine in designer.But when I view the report in cr viewer I am getting data like this.

2,014.00-2,015.00

I want to remove decimals and comas

Upvotes: 6

Views: 43252

Answers (3)

Fernando Meneses Gomes
Fernando Meneses Gomes

Reputation: 867

ToText parameters:

ToText(x, y, z, w)

x = The number to convert to text y = The number of decimal places to include in result (optional). The value will be rounded to that decimal place. z = The character to use as the thousands separator. If you don’t specify one, it will use your application default. (Optional.) w = The character to use as the decimal separator. If you don’t specify one, it will use your application default. (Optional.)

Upvotes: 0

Abdul Khaliq
Abdul Khaliq

Reputation: 2285

Right-click on the field or formula Select Format Field On the Number tab, choose the format to use from the list or click Customize to create a custom format. Click OK

enter image description here

Website Link

Upvotes: 6

craig
craig

Reputation: 26262

Try:

ToText( ToNumber({FocusOnCustomer.YEAR}), "#")

Upvotes: 19

Related Questions