Using Crystal Reports 8.x and Oracle 9i tables:
I have a report that prints bar codes (3 of 9 font) for DNA samples using the following formula:
"*O " & {CODNA.DNA Case Key} & "*"
{CODNA.DNA Case Key} is a six digit number. On work stations that do not have Crystal Reports installed and configured to treat numbers without commas and two decimal places (where the reports run from a Crystal Report engine), the bar codes produced would not scan. The reason was that {CODNA.DNA Case Key} was being printed as "785,365.00" instead of "785365".
If I install Crystal Reports on the computer and set the "Option" defaults to print numbers without formatting, the bar codes are fine. But I don't want to have to install Crystal Reports on 100 computers!
How can I insert formatting into my formula so that the number prints in the "-1123" format without having to manually change the workstation CR defaults?
I have a report that prints bar codes (3 of 9 font) for DNA samples using the following formula:
"*O " & {CODNA.DNA Case Key} & "*"
{CODNA.DNA Case Key} is a six digit number. On work stations that do not have Crystal Reports installed and configured to treat numbers without commas and two decimal places (where the reports run from a Crystal Report engine), the bar codes produced would not scan. The reason was that {CODNA.DNA Case Key} was being printed as "785,365.00" instead of "785365".
If I install Crystal Reports on the computer and set the "Option" defaults to print numbers without formatting, the bar codes are fine. But I don't want to have to install Crystal Reports on 100 computers!
How can I insert formatting into my formula so that the number prints in the "-1123" format without having to manually change the workstation CR defaults?