mibuso.com
Home› NAV/Navision Classic Client

Display Customer balances on the a report

kolaboykolaboy Member Posts: 446
edited 2007-11-27 in NAV/Navision Classic Client
Hi experts;
I have created a report that shows total payment and finance charge memo in a summary form. My problems now is how can i show the customers balance on the customer table on this report. Also when i preview this report globallly without putting a filter, the payments and the finance charge values of the top customer keeps adding on to the next below the line. this should not be the case.
Can anyone one help to stop the additions of these to the next. Also how can i show the Customer Balances on the report. Here is the report:
OBJECT Report 50078 testingSummary
{
  OBJECT-PROPERTIES
  {
    Date=26/11/07;
    Time=20:35:55;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table18;
        DataItemTableView=SORTING(No.);
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=Yes;
            SectionWidth=18150;
            SectionHeight=2538;
          }
          CONTROLS
          {
            { 1000000001;Label  ;0    ;0    ;7500 ;423  ;FontSize=8;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Cust. Ledger Entry }
            { 1000000003;TextBox;0    ;423  ;7500 ;423  ;SourceExpr=COMPANYNAME }
            { 1000000002;TextBox;14850;0    ;3150 ;423  ;HorzAlign=Right;
                                                         SourceExpr=FORMAT(TODAY,0,4) }
            { 1000000004;TextBox;17550;423  ;450  ;423  ;CaptionML=ENU=Page;
                                                         SourceExpr=CurrReport.PAGENO }
            { 1000000005;Label  ;16800;423  ;750  ;423  ;ParentControl=1000000004 }
            { 1000000006;TextBox;15750;846  ;2250 ;423  ;HorzAlign=Right;
                                                         SourceExpr=USERID }
            { 1000000012;Label  ;150  ;1269 ;2700 ;846  ;ParentControl=1000000011;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000009;Label  ;5850 ;1269 ;1500 ;846  ;HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Payment }
            { 1000000018;Label  ;8700 ;1269 ;1800 ;846  ;HorzAlign=Center;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         MultiLine=Yes;
                                                         CaptionML=ENU=Interest }
            { 1000000023;Label  ;11250;1269 ;1950 ;846  ;VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         CaptionML=ENU="Principal " }
            { 1000000007;Label  ;13650;1269 ;1500 ;846  ;HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontSize=8;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Balance }
          }
           }
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=18150;
            SectionHeight=0;
          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=Footer;
            PlaceInBottom=No;
            SectionWidth=18150;
            SectionHeight=1269;
          }
          CONTROLS
          {
            { 1000000010;TextBox;8250 ;0    ;2700 ;423  ;HorzAlign=Center;
                                                         FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotAmount }
            { 1000000013;TextBox;10950;0    ;2700 ;423  ;HorzAlign=Center;
                                                         FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotPrincipal }
            { 1000000014;TextBox;13800;0    ;2550 ;423  ;HorzAlign=Center;
                                                         FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotCustBal1 }
            { 1000000015;Label  ;0    ;0    ;2250 ;423  ;FontSize=9;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Total }
            { 1000000008;TextBox;5550 ;0    ;2400 ;423  ;HorzAlign=Center;
                                                         FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=GTPyment }
            { 1000000017;TextBox;5550 ;846  ;2550 ;423  ;HorzAlign=Center;
                                                         FontSize=10;
                                                         FontBold=Yes;
                                                         SourceExpr=GTPymentLCY }
            { 1000000019;TextBox;8250 ;846  ;2700 ;423  ;HorzAlign=Center;
                                                         FontSize=10;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotAmountLCY }
            { 1000000020;TextBox;10950;846  ;2700 ;423  ;HorzAlign=Center;
                                                         FontSize=10;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotPrincipalLCY }
            { 1000000024;TextBox;13800;846  ;2700 ;423  ;HorzAlign=Center;
                                                         FontSize=10;
                                                         FontBold=Yes;
                                                         SourceExpr=GTotCustBal1LCY }
            { 1000000025;Label  ;0    ;846  ;3000 ;423  ;FontSize=10;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Total ( LCY) }
          }
           }
      }
       }
    { PROPERTIES
      {
        DataItemIndent=1;
        DataItemTable=Table21;
        DataItemTableView=SORTING(Customer No.,Posting Date,Currency Code)
                          ORDER(Ascending)
                          WHERE(Document Type=FILTER(Finance Charge Memo|Payment),
                                Reversed=CONST(No));
        NewPagePerRecord=No;
        OnPreDataItem=BEGIN
                        LastFieldNo := FIELDNO("Customer No.");
                      END;

        OnAfterGetRecord=BEGIN
                           GTPyment := 0;
                           GTotAmount := 0;
                           GTotPrincipal := 0;
                           GTotCustBal1 :=0;

                           TotalCustBal := "Detailed Cust. Ledg. Entry"."Amount (LCY)";
                           CustBal1 := "Cust. Ledger Entry". Amount;
                           TotCustBal1 += CustBal1;


                           IF "Document Type"="Document Type"::Payment THEN  BEGIN
                             Pyment:= Amount;
                             Amount := 0;
                           END ELSE
                           IF "Document Type"="Document Type"::"Finance Charge Memo" THEN  BEGIN
                             Pyment:= 0;


                           END;
                           Principal :=Pyment- Amount;
                           TPyment += Pyment;
                           TotAmount += Amount-"Cust. Ledger Entry"."Remaining Amount";
                           TotPrincipal += Principal;

                           GTPyment := TPyment;
                           GTotAmount += TotAmount;
                           GTotPrincipal  += TotPrincipal ;
                           GTotCustBal1 += TotCustBal1;

                           Currency.InitRoundingPrecision;
                           IF "Currency Code" <> '' THEN
                             GTPymentLCY :=
                               ROUND(
                                 CurrExchRate.ExchangeAmtFCYToLCY(
                                   "Posting Date","Currency Code",
                                   GTPyment,CurrExchRate.ExchangeRate("Posting Date","Currency Code")),
                                 Currency."Amount Rounding Precision")
                           ELSE
                             GTPymentLCY :=
                               ROUND(GTPyment,Currency."Amount Rounding Precision");



                           Currency.InitRoundingPrecision;
                           IF "Currency Code" <> '' THEN
                             GTotAmountLCY :=
                               ROUND(
                                 CurrExchRate.ExchangeAmtFCYToLCY(
                                   "Posting Date","Currency Code",
                                   GTotAmount,CurrExchRate.ExchangeRate("Posting Date","Currency Code")),
                                 Currency."Amount Rounding Precision")
                           ELSE
                             GTotAmountLCY :=
                               ROUND(GTotAmount,Currency."Amount Rounding Precision");



                           Currency.InitRoundingPrecision;
                           IF "Currency Code" <> '' THEN
                             GTotPrincipalLCY :=
                               ROUND(
                                 CurrExchRate.ExchangeAmtFCYToLCY(
                                   "Posting Date","Currency Code",
                                   GTotPrincipal,CurrExchRate.ExchangeRate("Posting Date","Currency Code")),
                                 Currency."Amount Rounding Precision")
                           ELSE
                             GTotPrincipalLCY :=
                               ROUND(GTotPrincipal,Currency."Amount Rounding Precision");

                           Currency.InitRoundingPrecision;
                           IF "Currency Code" <> '' THEN
                             GTotCustBal1LCY :=
                               ROUND(
                                 CurrExchRate.ExchangeAmtFCYToLCY(
                                   "Posting Date","Currency Code",
                                   GTotCustBal1,CurrExchRate.ExchangeRate("Posting Date","Currency Code")),
                                 Currency."Amount Rounding Precision")
                           ELSE
                             GTotCustBal1LCY :=
                               ROUND(GTotCustBal1,Currency."Amount Rounding Precision");
                         END;

        ReqFilterFields=Customer No.;
        CalcFields=Amount;
        DataItemLink=Customer No.=FIELD(No.),
                     Posting Date=FIELD(Date Filter);
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=No;
            SectionWidth=18150;
            SectionHeight=0;
          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=18150;
            SectionHeight=0;
          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=Footer;
            PrintOnEveryPage=No;
            PlaceInBottom=No;
            SectionWidth=18150;
            SectionHeight=846;
          }
          CONTROLS
          {
            { 1000000016;TextBox;8850 ;0    ;1500 ;423  ;HorzAlign=Center;
                                                         SourceExpr=TotAmount }
            { 1000000021;TextBox;5850 ;0    ;1500 ;423  ;SourceExpr=TPyment }
            { 1000000022;TextBox;11250;0    ;1500 ;423  ;SourceExpr=TotPrincipal }
            { 1000000011;TextBox;0    ;0    ;1500 ;423  ;HorzAlign=Left;
                                                         SourceExpr="Customer No." }
            { 1000000000;TextBox;13800;0    ;1500 ;423  ;SourceExpr=TotCustBal1 }
            { 1000000026;TextBox;16200;0    ;1500 ;423  ;SourceExpr="Cust. Ledger Entry"."Remaining Amount" }
          }
           }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {
    VAR
      LastFieldNo@1000000000 : Integer;
      FooterPrinted@1000000001 : Boolean;
      TotalFor@1000000002 : TextConst 'ENU="Total for "';
      TotalCustBal@1000000003 : Decimal;
      CustBal1@1000000004 : Decimal;
      TotCustBal1@1000000005 : Decimal;
      "Detailed Cust. Ledg. Entry"@1000000006 : Record 379;
      Pyment@1000000007 : Decimal;
      Principal@1000000008 : Decimal;
      GTotCustBal1@1000000009 : Decimal;
      TPyment@1000000010 : Decimal;
      TotAmount@1000000011 : Decimal;
      TotPrincipal@1000000012 : Decimal;
      GTPyment@1000000013 : Decimal;
      GTotAmount@1000000014 : Decimal;
      GTotPrincipal@1000000015 : Decimal;
      Currency@1000000020 : Record 4;
      CurrExchRate@1000000019 : Record 330;
      AmountLCY@1000000018 : Decimal;
      AmountFCY@1000000017 : Decimal;
      InitMonth@1000000016 : Integer;
      GTPymentLCY@1000000021 : Decimal;
      GTotAmountLCY@1000000022 : Decimal;
      GTotPrincipalLCY@1000000023 : Decimal;
      GTotCustBal1LCY@1000000024 : Decimal;
      AmtPaid@1000000025 : Decimal;

    BEGIN
    END.
  }
}
Can somebody help please?
Thanks

Comments

  • SavatageSavatage Member Posts: 7,142
    Run This Report it does everything You want - you can arrange the fields the way you want in the sections - but it breaks up the finance charges from the payments and shows the customers current balance. I even added the option of showing or not showing the details.

    Download the fob here:
    http://savatage99.googlepages.com/50081 ... Report.fob

    or read the text (I suggest the fob) 
    OBJECT Report 50081 Kolaboy-Report
{
  OBJECT-PROPERTIES
  {
    Date=11/26/07;
    Time=[ 5:09:34 PM];
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table21;
        DataItemTableView=SORTING(Customer No.,Posting Date,Currency Code)
                          WHERE(Document Type=FILTER(Payment|Invoice|Finance Charge Memo));
        NewPagePerGroup=Yes;
        OnPreDataItem=BEGIN
                        LastFieldNo := FIELDNO("Customer No.");
                        CurrReport.CREATETOTALS(vBalance,vFinanceCharge,vPayment);
                        Customer.CALCFIELDS("Balance ($)");
                      END;

        OnAfterGetRecord=BEGIN
                           CASE "Document Type" OF
                             "Document Type"::Payment:
                                vPayment := "Cust. Ledger Entry"."Amount ($)";
                             ELSE
                                vPayment := 0;
                           END;
                           CASE "Document Type" OF
                             "Document Type"::"Finance Charge Memo":
                                vFinanceCharge := "Cust. Ledger Entry"."Amount ($)";
                             ELSE
                                vFinanceCharge := 0;
                           END;

                           Customer.GET("Cust. Ledger Entry"."Customer No.");
                           vBalance := Customer."Balance ($)";
                         END;

        ReqFilterFields=Customer No.;
        TotalFields=Original Amt. ($),Remaining Amt. ($),Amount ($);
        GroupTotalFields=Customer No.;
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=Yes;
            SectionWidth=18150;
            SectionHeight=1692;
          }
          CONTROLS
          {
            { 1000000001;Label  ;0    ;0    ;7500 ;423  ;FontSize=8;
                                                         FontBold=Yes;
                                                         CaptionML=ENU=Cust. Ledger Entry }
            { 1000000002;TextBox;15000;0    ;3150 ;423  ;HorzAlign=Right;
                                                         SourceExpr=FORMAT(TODAY,0,4) }
            { 1000000003;TextBox;0    ;423  ;7500 ;423  ;SourceExpr=COMPANYNAME }
            { 1000000004;TextBox;17700;423  ;450  ;423  ;CaptionML=ENU=Page;
                                                         SourceExpr=CurrReport.PAGENO }
            { 1000000005;Label  ;16950;423  ;750  ;423  ;ParentControl=1000000004 }
            { 1000000006;TextBox;15900;846  ;2250 ;423  ;HorzAlign=Right;
                                                         SourceExpr=USERID }
          }
           }
        { PROPERTIES
          {
            SectionType=Header;
            PrintOnEveryPage=Yes;
            SectionWidth=18150;
            SectionHeight=1269;
          }
          CONTROLS
          {
            { 1000000012;Label  ;0    ;0    ;1500 ;846  ;ParentControl=1000000011;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000015;Label  ;1650 ;0    ;300  ;846  ;ParentControl=1000000014;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000018;Label  ;2100 ;0    ;1500 ;846  ;ParentControl=1000000017;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000021;Label  ;3750 ;0    ;4500 ;846  ;ParentControl=1000000020;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000024;Label  ;8400 ;0    ;1800 ;846  ;ParentControl=1000000023;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000027;Label  ;10350;0    ;1800 ;846  ;ParentControl=1000000026;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000030;Label  ;12300;0    ;1800 ;846  ;ParentControl=1000000029;
                                                         HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes }
            { 1000000010;Label  ;14250;0    ;1500 ;846  ;HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes;
                                                         CaptionML=ENU=Payment }
            { 1000000013;Label  ;15750;0    ;1500 ;846  ;HorzAlign=Right;
                                                         VertAlign=Bottom;
                                                         FontBold=Yes;
                                                         MultiLine=Yes;
                                                         CaptionML=ENU=Finance Charge }
          }
           }
        { PROPERTIES
          {
            SectionType=GroupHeader;
            SectionWidth=18150;
            SectionHeight=0;
            OnPreSection=BEGIN
                           CurrReport.SHOWOUTPUT := FooterPrinted;
                           FooterPrinted := FALSE;
                         END;

          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=GroupHeader;
            SectionWidth=18150;
            SectionHeight=423;
            OnPreSection=BEGIN
                           CurrReport.SHOWOUTPUT :=
                             CurrReport.TOTALSCAUSEDBY = "Cust. Ledger Entry".FIELDNO("Customer No.");
                         END;

          }
          CONTROLS
          {
            { 1000000008;TextBox;3150 ;0    ;1500 ;423  ;HorzAlign=Left;
                                                         SourceExpr="Customer No." }
            { 1000000009;Label  ;0    ;0    ;3000 ;423  ;ParentControl=1000000008 }
          }
           }
        { PROPERTIES
          {
            SectionType=GroupHeader;
            SectionWidth=18150;
            SectionHeight=0;
            OnPreSection=BEGIN
                           CurrReport.SHOWOUTPUT :=
                             CurrReport.TOTALSCAUSEDBY = LastFieldNo;
                         END;

          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=18150;
            SectionHeight=423;
            OnPreSection=BEGIN
                           CurrReport.SHOWOUTPUT := PrintDetail;
                         END;

          }
          CONTROLS
          {
            { 1000000011;TextBox;0    ;0    ;1500 ;423  ;HorzAlign=Left;
                                                         SourceExpr="Customer No." }
            { 1000000014;TextBox;1650 ;0    ;300  ;423  ;HorzAlign=Left;
                                                         SourceExpr="Document Type" }
            { 1000000017;TextBox;2100 ;0    ;1500 ;423  ;HorzAlign=Left;
                                                         SourceExpr="Document No." }
            { 1000000020;TextBox;3750 ;0    ;4500 ;423  ;HorzAlign=Left;
                                                         SourceExpr=Description }
            { 1000000023;TextBox;8400 ;0    ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Original Amt. ($)" }
            { 1000000026;TextBox;10350;0    ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Remaining Amt. ($)" }
            { 1000000029;TextBox;12300;0    ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Amount ($)" }
            { 1000000016;TextBox;14250;0    ;1500 ;423  ;SourceExpr=vPayment }
            { 1000000019;TextBox;15900;0    ;1500 ;423  ;SourceExpr=vFinanceCharge }
          }
           }
        { PROPERTIES
          {
            SectionType=GroupFooter;
            SectionWidth=18150;
            SectionHeight=0;
            OnPreSection=BEGIN
                           IF NOT FooterPrinted THEN
                             LastFieldNo := CurrReport.TOTALSCAUSEDBY;
                           CurrReport.SHOWOUTPUT := NOT FooterPrinted;
                           FooterPrinted := TRUE;
                         END;

          }
          CONTROLS
          {
          }
           }
        { PROPERTIES
          {
            SectionType=GroupFooter;
            SectionWidth=18150;
            SectionHeight=846;
            OnPreSection=BEGIN
                           CurrReport.SHOWOUTPUT :=
                             CurrReport.TOTALSCAUSEDBY = "Cust. Ledger Entry".FIELDNO("Customer No.");
                         END;

          }
          CONTROLS
          {
            { 1000000031;TextBox;0    ;423  ;4500 ;423  ;SourceExpr=TotalFor + FIELDCAPTION("Customer No.") }
            { 1000000032;TextBox;8400 ;423  ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Original Amt. ($)" }
            { 1000000033;TextBox;10350;423  ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Remaining Amt. ($)" }
            { 1000000034;TextBox;12300;423  ;1800 ;423  ;HorzAlign=Right;
                                                         SourceExpr="Amount ($)" }
            { 1000000000;TextBox;14250;423  ;1500 ;423  ;SourceExpr=vPayment }
            { 1000000007;TextBox;15900;423  ;1500 ;423  ;SourceExpr=vFinanceCharge }
            { 1000000022;Shape  ;0    ;0    ;18000;423  ;ShapeStyle=HorzLine }
            { 1000000025;TextBox;6300 ;423  ;1800 ;423  ;SourceExpr=Customer."Balance ($)" }
            { 1000000028;Label  ;4800 ;423  ;1200 ;423  ;CaptionML=ENU=Balance-> }
          }
           }
      }
       }
    { PROPERTIES
      {
        DataItemIndent=1;
        DataItemTable=Table18;
        CalcFields=Balance ($);
        DataItemLink=No.=FIELD(Customer No.);
      }
      SECTIONS
      {
        { PROPERTIES
          {
            SectionType=Body;
            SectionWidth=18150;
            SectionHeight=0;
          }
          CONTROLS
          {
          }
           }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=5830;
      Height=1430;
    }
    CONTROLS
    {
      { 1000000000;CheckBox;4400;440  ;440  ;440  ;ShowCaption=No;
                                                   CaptionML=ENU=Print Customer Details;
                                                   SourceExpr=PrintDetail }
      { 1000000002;Label  ;440  ;440  ;3850 ;440  ;CaptionML=ENU=Print Customer Details }
    }
  }
  CODE
  {
    VAR
      LastFieldNo@1000000000 : Integer;
      FooterPrinted@1000000001 : Boolean;
      TotalFor@1000000002 : TextConst 'ENU="Total for "';
      vPayment@1000000003 : Decimal;
      vFinanceCharge@1000000004 : Decimal;
      vBalance@1000000006 : Decimal;
      PrintDetail@1000000005 : Boolean;

    BEGIN
    END.
  }
}
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kolaboykolaboy Member Posts: 446
    Thanks Savatage, This is fine. This is what i am looking for.
    Thanks once again.
  • kolaboykolaboy Member Posts: 446
    The Customers balance are ok in this reort. I tested it and its very good, but its finance charge Paid, Principal paid are not calcualting correctly as expected.
    The
    finance charge paid = Total finance charge - remaining Amount.
    Principal paid = total payment - finance charge paid

    also the finance charge memo should all appear under the finance charge column,all payments under the payment column and all Principal paid under the principal paid column.

    these are some of the things the report is lacking. If this is solved its gona be a perfect report. You may look at the report again to see how this can be fixed. It also considers application of payments first to Finance charges and if all the finance charges are cleared by the payment and the amount not finished then its goes on to be applied on the Opening Balance.

    I will be glade if someone can help on this. I am still trying to fix this but not luck yet.
    Thanks
  • SavatageSavatage Member Posts: 7,142
    Ok try this one
    http://savatage99.googlepages.com/50081 ... eport2.fob

    I'm not exactly sure what you are shooting for but this new report - breaks up almost everything. Use the fields you want & you can view the code behind it to see how it works.

    good luck
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
Sign In or Register to comment.