How to use the "left" option?

[tuigvlieg]

I have a database field that is a character field and looks like this 875.127.00.

I want to remove the last 2 zero's from the report. How should I do this?

I have already done this via the format field but it should also be possible via a formula.

Formula used: Left ({tsdsmd.dosvlg},6)

Error message: " string is requested there

 

[IanWaterman]

For some reason Crystal thinks {tsdsmd.dosvlg} is not a string, I assume it is this field which returns 875.127.00

Are you sure you are using the correct field in the formula?

A way round the problem will be to convert to text first so formula will become.

Left (totext({tsdsmd.dosvlg}),6)
but this should not be necessary?

Ian

 

[Madawc]

Right-click on the field and select Format Field: see what you've got. If it is a number, you should be able to get rid of the decimal places.

Also check the thousand separator - should it be a full stop rather than a comma? Maybe it is, for your business or national set-up.

Depending on your version of Crystal, you might be able to use an icon to get rid of decimal places, or add them.

For a number, you could also try totext({tsdsmd.dosvlg}), 0) - which means no decimal places. The advantage of doing it this way is that it works on all machines, rather than changing when the report is run by someone with a different set-up.

Check ToText in [Help] - lots of interesting options

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10