Crystal Reports - barcodes scan with and without decimals

Yahoo Archive
1
Vic,

This worked for us - we have now changed a couple of reports and labels based on this.

Thank you,
Karen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Wednesday, February 06, 2013 9:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - barcodes scan with and without decimals



Thanks Vic, I will give this a try.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Vic Drecchio
Sent: Tuesday, February 05, 2013 1:41 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - barcodes scan with and without decimals

On your ToText() function, try using the additional arguments:

ToText({your_field},0,"")

The zero forces to NO decimals. I know the INT() should do that but I've
seen cases of formatting in Crystal where the ToText always dumps in
decimals.

The empty quotes ("") tell it to never use a comma (thousands separator).

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Karen Schoenung
Sent: Tuesday, February 05, 2013 2:07 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - barcodes scan with and without decimals

Hi all,
I have a Crystal Report that uses barcodes and formulas such as -
"*"+ToText(Int({orderrel.OrderNum}))+"$I"+"*". We use terminal servers to
connect to Epicor and different printers...On some printers this barcode
scans correctly as the integer only of the order number and a tab
character...On other printers this barcode scans with decimal places (order
number + .00). We have tested it is not the scanner - the same printed
report scans the same way with multiple scanners.

Does anyone have any ideas on what we can check into?

TIA,
Karen

No virus found in this message.
Checked by AVG - www.avg.comhttp://www.avg.com>
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13

-----
No virus found in this message.
Checked by AVG - www.avg.comhttp://www.avg.com>
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Hi all,
I have a Crystal Report that uses barcodes and formulas such as - "*"+ToText(Int({orderrel.OrderNum}))+"$I"+"*". We use terminal servers to connect to Epicor and different printers...On some printers this barcode scans correctly as the integer only of the order number and a tab character...On other printers this barcode scans with decimal places (order number + .00). We have tested it is not the scanner - the same printed report scans the same way with multiple scanners.

Does anyone have any ideas on what we can check into?

TIA,
Karen
3
On your ToText() function, try using the additional arguments:



ToText({your_field},0,"")



The zero forces to NO decimals. I know the INT() should do that but I've
seen cases of formatting in Crystal where the ToText always dumps in
decimals.



The empty quotes ("") tell it to never use a comma (thousands separator).







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karen Schoenung
Sent: Tuesday, February 05, 2013 2:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - barcodes scan with and without decimals





Hi all,
I have a Crystal Report that uses barcodes and formulas such as -
"*"+ToText(Int({orderrel.OrderNum}))+"$I"+"*". We use terminal servers to
connect to Epicor and different printers...On some printers this barcode
scans correctly as the integer only of the order number and a tab
character...On other printers this barcode scans with decimal places (order
number + .00). We have tested it is not the scanner - the same printed
report scans the same way with multiple scanners.

Does anyone have any ideas on what we can check into?

TIA,
Karen



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13

[Non-text portions of this message have been removed]
4
Thanks Vic, I will give this a try.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, February 05, 2013 1:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - barcodes scan with and without decimals



On your ToText() function, try using the additional arguments:

ToText({your_field},0,"")

The zero forces to NO decimals. I know the INT() should do that but I've
seen cases of formatting in Crystal where the ToText always dumps in
decimals.

The empty quotes ("") tell it to never use a comma (thousands separator).

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Karen Schoenung
Sent: Tuesday, February 05, 2013 2:07 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - barcodes scan with and without decimals

Hi all,
I have a Crystal Report that uses barcodes and formulas such as -
"*"+ToText(Int({orderrel.OrderNum}))+"$I"+"*". We use terminal servers to
connect to Epicor and different printers...On some printers this barcode
scans correctly as the integer only of the order number and a tab
character...On other printers this barcode scans with decimal places (order
number + .00). We have tested it is not the scanner - the same printed
report scans the same way with multiple scanners.

Does anyone have any ideas on what we can check into?

TIA,
Karen

No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13

-----
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2238 / Virus Database: 2639/5583 - Release Date: 02/05/13

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]