Barcode and thousand weparator problem

Kisu

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

tooo

Sounds like an issue with the font your using! Maybe try a different font?

Kisu

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

tooo

Don't know it it'll solve your problem but try using the CONVERTSTR function.

Kisu

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

Kisu

Ah solved
Got it working like this.
It deletes the space separator and changes the comma into period
CONVERTSTR(DELCHR('!'+FORMAT("[the desimal value]")+'!','=',' '),',','.')

Slawek_Guzek

perhaps FORMAT(decimalvalue,0,2) would be easier...

Regards,
Slawek

Kisu

Slawek Guzek wrote:

perhaps FORMAT(decimalvalue,0,2) would be easier...

Regards,
Slawek

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