Dear Baan Expert,
I facing a problem on display AMOUNT in report.
Example
Qty X Amount
Qty =2 (ZZZ9)
Amount =40.45 (ZZZZ9VD99)

Report Display is (XXX2 x XXX40.45)
X = Space

I would like to print the amount start print from left to right.
2 x 40.45

Please Help

Instead of printing numbers you could print strings and use shiftl$(). You might even be able to play with the alignment on the report by not linking to the domain. Never really tried that myself.

Instead of printing numbers you could print strings and use shiftl$(). You might even be able to play with the alignment on the report by not linking to the domain. Never really tried that myself.

Hello,

but pay attention, yo'll not able to calculate with strings.
Calculation must be done in the background and results should be converted to strings.

Never had a need do something like that.

2 x 10,00 = 20,00
50 x 2,00 = 100,00
1,25 x 14,25 = 17,81

This would be the result. Looks strange ?

Regards

Dear All,
Thanks for your information.

I will try on it (convert to string).

Thank you so much.

you can try out like this...

strip$(shiftl$(str$(qty))) & "x" & strip$(shiftl$(str$(Amount)))

Please note that the above code won't do the calculation. This is just to display the desired output.

Dear Baan Experts,
I been tried the script provided, the output is as per below :-

Data
7.1000 + 8.9100

Output (suggested Script)
7.1 + 8.91

Desired Output
7.1000 + 8.9100


Please help

Hi,

If var1 = 7.1000 & var2 = 8.9100

then try:
sprintf$("%-5.4f", var1) & " x " & sprintf$("%-5.4f", var2)

Hope it helps you.

Regards,
--Rahul.