Designing Reports

kolaboy

Hi Experts,
I am trying to design a report from scratch using the Cust. Ledger Entry table and the Detailed Cust. ledger Entry table as my dataitems so that i can display the payments made and the Finance charge Memos which have been applied for each customer.
The report should show the amounts paid under one column called amount and the finance charges under the finance charge column separately. The finance charge should show only the finance charge that are applied.

I tried doing this but my problem is, the finance charge column amounts are not showing the finance charges but addition of some figures which i don't know. Here is a text format of my objects:

OBJECT Report 50020 TwoDataItem
{
  OBJECT-PROPERTIES
  {
    Date=18/07/07;
    Time=[ 0:44:14];
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table21;
        DataItemTableView=SORTING(Entry No.)
                          ORDER(Ascending)
                          WHERE(Document Type=FILTER(Finance Charge Memo),
                                Document Type=FILTER(Payment));
        GroupTotalFields=Document Type;
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=Yes;
            SectionWidth=25650;
            SectionHeight=846;
          }
          CONTROLS
          {
            { 1000000009;Label  ;0    ;0    ;1500 ;846  ;ParentControl=1000000008;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000011;Label  ;1650 ;0    ;1800 ;846  ;ParentControl=1000000010;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000013;Label  ;3600 ;0    ;1200 ;846  ;ParentControl=1000000012;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000015;Label  ;5550 ;0    ;1650 ;846  ;ParentControl=1000000014;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000017;Label  ;8100 ;0    ;1800 ;846  ;ParentControl=1000000016;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
          }
           }
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=25650;
            SectionHeight=846;
          }
          CONTROLS
          {
            { 1000000008;TextBox;150  ;0    ;1350 ;423  ;SourceExpr="Entry No." }
            { 1000000010;TextBox;1650 ;0    ;1500 ;423  ;SourceExpr="Customer No." }
            { 1000000012;TextBox;3600 ;0    ;1200 ;423  ;SourceExpr="Posting Date" }
            { 1000000014;TextBox;5550 ;0    ;1500 ;423  ;SourceExpr="Document Type" }
            { 1000000016;TextBox;8100 ;0    ;1800 ;423  ;SourceExpr=Amount }
          }
           }
      }
       }
    { PROPERTIES
      {
        DataItemIndent=1;
        DataItemTable=Table379;
        DataItemTableView=SORTING(Customer No.,Posting Date,Entry Type,Currency Code)
                          ORDER(Ascending)
                          WHERE(Entry Type=FILTER(Application),
                                Initial Document Type=FILTER(Payment));
        ReqFilterFields=Customer No.,Posting Date;
        TotalFields=Amount,Credit Amount;
        GroupTotalFields=Document Type;
        DataItemLink=Cust. Ledger Entry No.=FIELD(Entry No.);
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=GroupFooter;
            SectionWidth=25650;
            SectionHeight=423;
          }
          CONTROLS
          {
            { 1000000000;TextBox;150  ;0    ;3300 ;423  ;SourceExpr="Posting Date" }
            { 1000000002;TextBox;10800;0    ;1800 ;423  ;SourceExpr=Amount }
            { 1000000004;TextBox;4950 ;0    ;1500 ;423  ;SourceExpr="Customer No." }
            { 1000000006;TextBox;13500;0    ;1800 ;423  ;SourceExpr="Credit Amount" }
          }
           }
        { PROPERTIES
          {
            SectionType=Footer;
            PrintOnEveryPage=No;
            SectionWidth=25650;
            SectionHeight=846;
          }
          CONTROLS
          {
            { 1000000018;TextBox;10800;0    ;1800 ;423  ;SourceExpr=Amount }
            { 1000000001;TextBox;13650;0    ;1800 ;423  ;SourceExpr="Credit Amount" }
          }
           }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {

    BEGIN
    END.
  }
}

Can anyone help me out to get this correct please!!!
Thanks

kolaboy

Hi exprts,
I am still waiting for you ideas on this post. I still can't make a headway.
I need your help Please!!!! ](*,) ](*,) ](*,)