User Id :    Password :      New Member   Forgot Password  
Topic: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Faiz
30 Sep 2011 at 02:18 AM

Please help me

create a data set  in one  field  data type is single, but when display in crystal report then does not shows 3 decimal value in report.Only show 2 decimal point value (I do not change the property of data field in decimal point)

Re: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Najmul Hoda
01 Oct 2011 at 09:53 AM

Hi Faiz,

You can use Fix(number, decimals) in the formula to get the desired result.

It returns a number with a specified number of significant digits.

Hope this will help you.

 

Re: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Faiz
03 Oct 2011 at 12:08 AM

Hi najmul

Thanks for support.

It is always rounding to 2 significant decimal. Does not shows the 0.523

fix(number,decimals)

Fix(0.523,3)

Result is

 0.52

but i want =0.523

 

 

Re: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Faiz
03 Oct 2011 at 12:08 AM

Hi najmul

Thanks for support.

It is always rounding to 2 significant decimal. Does not shows the 0.523

fix(number,decimals)

Fix(0.523,3)

Result is

 0.52

but i want =0.523

 

 

Re: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Faiz
03 Oct 2011 at 12:09 AM

Hi najmul

Thanks for support.

It is always rounding to 2 significant decimal. Does not shows the 0.523

fix(number,decimals)

Fix(0.523,3)

Result is

 0.52

but i want =0.523

 

 

Re: How to display 3 decimal point value like 0.234 in crystal report field using asp.net
Faiz
03 Oct 2011 at 12:09 AM

Hi najmul

Thanks for support.

It is always rounding to 2 significant decimal. Does not shows the 0.523

fix(number,decimals)

Fix(0.523,3)

Result is

 0.52

but i want =0.523

 

 

Total Replies: 5
 
Featured Text Ad

Featured Ad