Post reply

Barcode font 128b -SQL function

  • October 16, 2014 at 7:38 am

    #1752860

    trwillcox (10/16/2014)

    Just tested about 1000 barcodes generated with the updated code and they all worked.

    Thanks for all your help MM. Hopefully I wont be bothering you again!!

    No problem, thanks for your testing 😛

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • October 16, 2014 at 7:50 am

    #1752864

    Good One Mr.mister.magoo

  • October 16, 2014 at 8:07 am

    #1752874

    Hello Mr. i am eager to know how the "-- build an inline fast tally table" works if possible could u please Explain:-)

  • October 16, 2014 at 8:23 am

    #1752879

    Ya I found Mr. its CTE Correct? 🙂

  • October 20, 2014 at 7:59 pm

    #1753649

    Hi, M.M.

    Thanks man for your kind help...

    I solved my problem, but my troubleshoot is very funny. I downgraded VS 2013 to VS 2010, and voila using font Free3Of9; it solved my issue. Anyway, thanks for help!!!:-D

    For those who are looking ahead for barcode printing,

    there is another work around, just download Free3Of9 font and install it on machine. In SSRS, change your barcode expression as ="*"+Fields!BARCODE.Value+"*"

    where Fields!BARCODE.Value is value you want to provide to barcode.

    set font for above textbox as Free3Of9. I am able to scan barcode printed using above technique with font size 18pt also.

  • September 17, 2015 at 3:17 am

    #1827316

    Dear M.M,

    I have a SSRS report with code 128 font, the stored procedure use your function to generate code 128 char, the report printed in pdf with barcode. But my scanner unable to read the barcode.

    Please help me as customer only need code 128B.

    My scanner can read the barcode using font 3 of 9 but cant read code 128, looks like the start bar and end bar not correct.

    • Viewing 6 posts - 16 through 20 (of 20 total)

    You must be logged in to reply to this topic. Login to reply