I am developing a routine that will print a barcode label from an application in VFP using Crystal Reports as the print engine.
This application uses SQL Server as a backend but uses VFP cursors converted to FOX2X type tables which are sent from the application to the Crystal Reports RDC engine. I was never able to get Crystal Reports to get the data directly from SQL Server using ODBC or ADO-DB, that's why I use FOX2X type tables.
So, I need a function that prints the air waybill number (letters and numbers) as a Code 128 barcode in Crystal Reports. For that I have seen that I need a function that converts the air waybill number into the correct string so that, using the correct font, the Code 128 barcode is displayed that is readable by a scanner gun.
I have tried a few routines in VFP, SQL Server, and even Crystal Reports, they all give me different results, but none of them show a barcode that is readable by a scanner. I have even come to think that the Code 128 font I am using is not appropriate.
So, I need your help, maybe someone in this forum knows the right way to do what I want.
TIA