You could split the amount into a the individual characters (or a text array) from NAV and then only have one character in each variable string in RDLC.
Andrian, you know the length (by FORMAT command) of string from the decimal, right?
You know how many symbols you have on the page, right? The very simple way (e.g. FOR…DOWNTO) to fill the Array or Chars (or String) and transfer it to Dataset.
Hi Erik, I’ll try this suggestion, but since I’m using =sum() in my expression in the report layout. I’m not quite sure how do I use this approach. I’ll see to it though , now my problem for the splitting part is that. first I need to get the final value of my amount so I could convert it into a string. and do the splitting.
you are trying to fill from “left-to-right & First-to-last symbol”, but you need to fill from “right-to-left & from-last-to-first symbol”
Let’s imagine we have DecValue = “24.86”. We have new TXT line PrintLine[14] where PrintLine[12] = ‘.’
to receive 2 symbols after ‘.’ we should do something like PrintLine[13] := COPYSTR(FORMAT(DecValue-ROUND(DecValue,1)), 1,2)
For “integer part” we should do either FOR-circle with DOWNTO type calculation or DO, WHILE (it is up to you) → fill either Symbol from “integer part” or " ".