Barcode and thousand weparator problem

Kisu
Kisu Member Posts: 381
edited 2008-10-02 in NAV/Navision Classic Client
What to do, when we have fixed the barcode font on a report and when we print it, it gives a space (which is not space realy) between thousand numbers. The barcode gets huge gap between the lines too and wont work because of that :-k
K.S.

Answers

  • tooo
    tooo Member Posts: 138
    Sounds like an issue with the font your using! Maybe try a different font?
  • Kisu
    Kisu Member Posts: 381
    Dont think so, the thousand separator goes to the other fonts aswell.
    I tryed to use FORMAT function to change the separator position, but it either goes in near the begining, the middle or near the end of that barcode.

    I know it has something to do with the Windows font setup where there is this lineseparator, but if I take it off from there. Everywhere in navision the separators dissapear. Would it be possible to just take it off from the report.

    Example.
    3 060 <- Threethousandsixty 3[gap]060
    ||| [gap] |||| |||| | ||

    ^^^^ it leavese gap like that like it has in the number
    K.S.
  • tooo
    tooo Member Posts: 138
    Don't know it it'll solve your problem but try using the CONVERTSTR function.
  • Kisu
    Kisu Member Posts: 381
    tooo wrote:
    Don't know it it'll solve your problem but try using the CONVERTSTR function.

    Tryed, didn't work.
    The function needs something to replace the gap which is not good since we need just to get it out :-k
    K.S.
  • Kisu
    Kisu Member Posts: 381
    Ah solved :)
    Got it working like this.
    It deletes the space separator and changes the comma into period
    CONVERTSTR(DELCHR('!'+FORMAT("[the desimal value]")+'!','=',' '),',','.')
    K.S.
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    perhaps FORMAT(decimalvalue,0,2) would be easier...

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • Kisu
    Kisu Member Posts: 381
    Slawek Guzek wrote:
    perhaps FORMAT(decimalvalue,0,2) would be easier...

    Regards,
    Slawek

    That didnt work, tryed it before. it leaves a space there.
    K.S.

Categories