Reputation: 323
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
So how i remove this 0 from serial number ?
Upvotes: 1
Views: 747
Reputation: 1182
Right click on that field and Go to Format_Field..
--> Numbers
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