Crystal xi - string numbers together without decimal places -
i need build text field stringing 2 numbers barcode.
for example: fld1
12345678 , fld2
145.99. fld1
needs 9 characters long, 0 filled , fld2
needs 8 characters long, 0 filled.
i need string 01234567800014599
there 2 step do. 1 need concatenation, '+' used concatenate. leading 0 can utilize right function (refer below link)
totext({table1.fld1},"000000000") + totext({table1.fld1},"000000000") or right("0000"&{table1.fld2},8) + right("0000"&{table1.fld2},8)
just check link :- padding fixed number leading zeros fixed length
crystal report; combining rows of info single value
crystal-reports
No comments:
Post a Comment