Best Of

create a variable to store the cumulative sum and assign the value on OnafterGetRecord of your detail data item .

example : RemAmoutLCYSUM := RemAmoutLCYSUM + Remaining Amount (LCY)

use the variable as expression for your new column

kriki wrote:

kriki wrote:

datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));

Did see that also the last day of the month was needed:

datLastDayOfMonth := CALCDATE('<1M>',datFirstDayOfMonth) - 1;

Or in generaly:

datLastDayOfMonth := CALCDATE('<CM>',datMyDate);

8)

Not in Word templates. In RDLC you could create a textbox with Wingdings font and based on Boolean value set the text to either character 253 (box with cross in it, aka "No") or 254 (box with tickmark in it, aka "Yes").
Word templates do not support such conditional boxes, which is why it won't work that way.
That being said, if you were to form your own table, have the left-most column in some kind of symbol font, like Wingdings, and pass a single character, representing the code of the character you want into it, then it might be possible. Though it will take some playing around with both the template and the dataset

Hi there!

If you want to replace a substring with new subtring which contains the same charachters, the ReplaceString function by nelson will cycling over the loop. So you can use the following function:

LOCAL ReplaceString(String : Text;FindWhat : Text;ReplaceWith : Text) NewString : Text
FindPos := STRPOS(String,FindWhat);
WHILE FindPos > 0 DO BEGIN
  NewString += DELSTR(String,FindPos) + ReplaceWith;
  String := COPYSTR(String,FindPos + STRLEN(FindWhat));
  FindPos := STRPOS(String,FindWhat);  
END;
NewString += String;

For example, if you want escape characters in XML you can use:

ReplaceString(XMLBody,'"','\"');

Input:
<FullName>Публичное акционерное общество "Рога и Копыта"</FullName>

Output:
<FullName>Публичное акционерное общество \"Рога и Копыта\"</FullName>