Saturday, 15 June 2013

Crystal xi - string numbers together without decimal places -



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