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;
}
Below is the screenshot of my required format.
I have highlighted the Original Amount and Running Total columns in green.
