Dynamics Community Forum Thread Details

Business Central RDLC: Running Total Issue with Currency Field in Customer Statement Default Report

Hi,

I am working with a Business Central default Customer Statement report that uses RDLC Default layout:

1. When the currency field is empty, one table is shown in the report output.
2. When the currency field has a value, a separate table is shown in the report output.

Below is a screenshot example of the default report format.

My requirement:
I want the report to always show only one format (one table), regardless of whether the currency field is empty or not.
How can I modify the RDLC to display only one table for all cases?

I am trying this code to display the output as shown in the screenshot below.

I have created a report using one table, but I am facing running total issues. I tried the following Report Extension code

  modify(DtldCustLedgEntries)
        {
            RequestFilterFields = "Initial Entry Global Dim. 1", "Initial Entry Global Dim. 2";
            trigger OnAfterAfterGetRecord()
            var
                custledentries: Record "Cust. Ledger Entry";
                GLSetup: Record "General Ledger Setup";
            begin
               
                if "Currency Code" = '' then begin
                    "Currency Code" := GLSetup."LCY Code";
                end;
            end;
        }
        modify(CustLedgEntry2)
        {
            trigger OnAfterAfterGetRecord()
            var
                GLSetup: Record "General Ledger Setup";
            begin
                if "Currency Code" = '' then begin
                    "Currency Code" := GLSetup."LCY Code";
                end;
            end;
        }