Print to Excel Groupfooter Totals

Lamba

Hi Experts,

I have report which has Export to Excel option, the same has to be done for Rtc.
So i have a code on Grpfooter section of Customer as


CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO("Customer Posting Group");
IF (ExportToXL AND CurrReport.SHOWOUTPUT) THEN BEGIN
EnterCell(i,1,Text004 +FORMAT(' ') + "Customer Posting Group",FALSE,FALSE);
EnterCell(i,2,'',FALSE,FALSE);
EnterCell(i,3,FORMAT(PeriodBeginBalance),FALSE,FALSE);
EnterCell(i,4,FORMAT(PeriodDebitAmt),FALSE,FALSE);
EnterCell(i,5,FORMAT(PeriodCreditAmt),FALSE,FALSE);
EnterCell(i,6,FORMAT(YTDBeginBalance),FALSE,FALSE);
EnterCell(i,7,FORMAT(YTDDebitAmt),FALSE,FALSE);
EnterCell(i,8,FORMAT(YTDCreditAmt),FALSE,FALSE);
EnterCell(i,9,FORMAT(YTDTotal),FALSE,FALSE);
i:=i+1;
END;

I have shifted the code on Customer's OnPostdataitem, i am unable to get the total as
the code has CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO("Customer Posting Group");
that is unsupportable in Rtc.

What is the alternative, i have searched in Help but there was no alternative for Rtc.