Insert 3 fields into one barcode on Crystal Reports

Posted on 2011-05-05
Last Modified: 2012-05-11
Hi all.

I'm using Crystal Reports 8.5 and I have a barcode that when scanned it reads the salesordernumber. I want to be able to also read the state and zipcode. Is there a way I can do this with one barcode? So when scanned it will populate the salesordernumber then the state and then the zip code all with one scan instead of having to scan 3 barcodes I want to be able to do it with one.

Is this possible? Thank you in advance!
Question by:printmedia
    LVL 77

    Accepted Solution

    I don't think this is a Crystal Reports issue.  Inputting data will be dealt with by your application program and/or database.  
    LVL 100

    Expert Comment

    Why did you ask this in Crystal?
    Is Crystal creating the barcode labels?

    If you concatenate the 3 fields into a single field with appropriate separators, can Crystal create the barcode?

    If so then you should be able to write code for the scanner that will separate the the three fields.


    LVL 1

    Expert Comment

    Hi Printmedia,

    You can certainly put all three fields into a single barcode as long as your scanner knows how to parse it.  You would create a new formula and concatenate all three fields:

    //barcode lead character
    //if sales order number is not a string you'll need to convert it.  Totext second arg allows you to control the commas and decimals.
    //concat state
    //concat zip
    //barcode end char

    You could also concatenate delimiters in there if your scanner needs it to parse the code.  Best of luck!  I have done barcodes in version 8.5 several times before... let me know if there is more I can do.


    Author Comment

    After peter's comment I realized he was right and I could do it in the application that was receiving the barcode scan, so I awarded him the points because he led me to my solution.
    LVL 100

    Expert Comment

    Great.  Just wanted to make sure the idea led to the solution.


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now