user6628729
user6628729

Reputation: 323

Remove 0 from s.no in crystal report

I add S.No in crystal report through database and when i add S.No field in report this show 0 at the end like this

1.00
2.00
3.00
4.00

and so on

so how i remove this when i left click on field i found these options

Format object
highlight expert
Browse field data
Select expert
insert
move
copy
delete
paste

check this image

image

enter image description here So how i remove this 0 from serial number ?

Upvotes: 1

Views: 747

Answers (1)

Ankur Alankar Biswal
Ankur Alankar Biswal

Reputation: 1182

Right click on that field and Go to Format_Field.. --> Numbers

enter image description here

You can also make these changes in Format Object. Otherwise you can create a formula:

@sno_number = tonumber(<RowNumber>); 

Then use sno_number in place of S.NO.

Upvotes: 1

Related Questions