RTC Report: Problem in adding Narration to Detail Trail Bal.

shettarvikas

Hi,

In Detail trail Bal. report, I have added Narration dataitem under GL Entry table and linked with Transaction No. Then in the sections, I have added Narration fields under the GL Entry.
Now in RDLC, report design, manually I created a group, copied the GL Entry body items into the new group and under that group, I created a body row and attached Narration.

Now, the problem is, if an entry has more than 1 narration line, the summation of credit/debit amount is calculated as no. of narration lines. Say If for an entry 'X' and amount = 100, and it has 3 narration lines, the summation for that entry is 300 where as it should be only 100.

This happens where ever this is narration for a entry.

Please suggest

Thanks in advance,

Regards,
Vikas

QuickWE

You must be ignored SUM Funtions at RTC Layout then
Add code

IF ISSERVICETIER THEN
Var1 += .........

on event OnAfterGetRecord and then take textbox to contains the Var1 and put its on anywhere and at RTC used LAST(VAR1.Value) instead of SUM Funtions.

I think,it might be useful for you.