Format Niumber in Indian Style

[Former Member]

Hi,

We are using crystal report 8.5 with VB 6

We want to format numbers in indian style i.e UK styl.e

Example:

if number is 1010100

then it should be display as 10,10,100 in crystal report.

I used System default format in Format field option also aftrer setting system format as UK System.

But no use.

Kindly give solution.

Regards

S. Muhilan

[former_member11696]

Please re-post if this is still an issue to the Legacy Application Development SDKs Forum or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

S=

Hi,

We are using crystal report 8.5 with VB 6

We want to format numbers in indian style i.e UK styl.e

Example:

if number is 1010100

then it should be display as 10,10,100 in crystal report.

I used System default format in Format field option also aftrer setting system format as UK System.

But no use.

This should just be a formatting issue. If you can't do the customization you want let me know the field type and the DB you are using. This shouldn't be an issue.

Make sure it's in num format if using a formula. if it's not use the "CBDL" function to do the calc

[Former Member]

Hi

Thanks for reply.

2 fields ( OpenBalance, CurrentAmt) are database fields of type float.

3 field is a formulat field which sum OpenBalance + CurrentAmt fields of Database fields

Regards

S. Muhilan

[Former Member]

Do the first two fields format correctly? and it's just the third ond you're having problems with?

[Former Member]

No.

All 3 fields are creating problem.

Regards

S. Muhilan

[Former Member]

Subramaniyan,

Ok, I'm not familiar with the formatting you desire, but you can try writing a formula to get the desired result. This can be done either as a separate formula field or in the field's formating.

Let me know if that helps.

Rob