I am trying to concatenate barcode in SSRS for the barcode to split out the fields so I can place them in the appropriate column. I need to get rid of the Box that appears in the Barcode. I assume it has to do with the separator somehow. I am using ASCII Code.
This is my expression.
And I get this.
Need to get rid of the box in the code.
Are you using a barcode font that handles those characters? Looks like you may need to use 3of9 extended.
If you want it to be two separte barcodes, you’ll ned the '*' at the end of the first and begining of the second.
= "*" + Format(...) + "*" + "%S" + "*" + Format(...) + "*";
Probably better to make it as two separate fields. The second barcode will move around as the first one changes length.
Just curious … what does the "%S" do?
Calvin -
When the ASCII Bacode Scanner reads the Concatenated Barcode it will put a Tilde as the separator. Then I can use it in C#.
When I scanned this code it wrote the tilde in the scan.
Sorry, I thought you were trying to make two barcodes.
Which barcode format are you using?
As a test, set that expression to what you expect to get (like: ="*1.00~321*"), and see if that renders. Then try…
="*" + Format(...) + "~" + "321" + "*"
then
="*" + Format(...) + "~" + Format(...) + "*"
then
="*" + Format(...) + "%S" + Format(...) + "*"
BTW - partnumber is already a string, so no need for the Format(…partnum,"#"). In fact that would mess up if the PartNum isn’t just numerical digits.
Calvin -
Great thought on the BTW. That Was my problem. When I took the convert to string off the PartNum it worked. I will post a screenshot of what if trying to accomplish in a little bit.
Thanks!!
