Small and medium business | Business Central, N...

How to add filter section for my customized report in Business Central?

(1) Share

Report

Posted on by CU07101338-0

Hello everyone,

I've created a new report in BC. I want to add filter section like this picture, but I do not know how can I proceed that.

When I use "ReqFilterFields", I see this error:

The property 'ReqFilterFields' cannot be used in this contextALAL0124
(property) ReqFilterFields

How can I add filter part to my customized report?

report 50103 "Vendor Collection"
{
    DefaultLayout = RDLC;
    RDLCLayout = 'VendorCollection.rdl';
    UsageCategory = Administration;
    ApplicationArea = All;

    dataset
    {
        dataitem(VendLedgEntry; "Vendor Ledger Entry")
        {
            DataItemTableView = sorting("Vendor No.", "Entry No.");

            // Example columns - no 'Caption' property here.
            column(VendorNo; "Vendor No.")
            {
            }

            column(VendorPostingDate; "Posting Date")
            {
            }

            column(Amount; Amount)
            {
            }

            column(CurrencyCode; "Currency Code")
            {
            }

            column(RunningBalance; RunningBalance)
            {
            }

            // Initialize and update RunningBalance
            trigger OnPreDataItem()
            begin
                RunningBalance := 0;
            end;

            trigger OnAfterGetRecord()
            begin
                RunningBalance += Amount;
            end;
        }
    }

    var
        RunningBalance: Decimal; 
}

Thanks in advance!

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

gdrenteria 12,544 Most Valuable Professional on at

Like (2)

Report

How to add filter section for my customized report in Business Central?

Hi, good day
I hope this can help you, and give you some hints.

How do I: Add filters in a Report in VSCode with AL? – think about IT

Best Regards
Gerardo
Suggested answer

Khushbu Rajvi. 5,192 on at

Like (2)

Report

How to add filter section for my customized report in Business Central?

You can take reference of this Vendor - Order Detail (308, Report Request)

Hope this helps as well.

https://yzhums.com/40072/

https://community.dynamics.com/forums/thread/details/?threadid=37adf077-32ce-42ce-adeb-d198c1dba769

https://yzhums.com/21007/
Suggested answer

Khushbu Rajvi. 5,192 on at

Like (2)

Report

How to add filter section for my customized report in Business Central?

Hi, Try with the below code:

report 50103 "Vendor Collection"

{

DefaultLayout = RDLC;

RDLCLayout = 'VendorCollection.rdl';

UsageCategory = Administration;

ApplicationArea = All;

dataset

{

dataitem(VendLedgEntry; "Vendor Ledger Entry")

{

DataItemTableView = sorting("Vendor No.", "Entry No.");

RequestFilterFields = "Vendor No.", "Vendor Name", "Vendor Posting Group"; //RK added

// Example columns - no 'Caption' property here.

column(VendorNo; "Vendor No.")

{

}

column(VendorPostingDate; "Posting Date")

{

}

column(Amount; Amount)

{

}

column(CurrencyCode; "Currency Code")

{

}

column(RunningBalance; RunningBalance)

{

}

// Initialize and update RunningBalance

trigger OnPreDataItem()

begin

RunningBalance := 0;

end;

trigger OnAfterGetRecord()

begin

RunningBalance += Amount;

end;

}

}

// RK-start

requestpage

{

layout

{

area(Content)

{

group("Options")

{

field(ShowAmountsInLCY; ShowAmountsInLCY)

{

ApplicationArea = All;

Caption = 'Show Amounts in LCY';

}

field(NewPagePerVendor; NewPagePerVendor)

{

ApplicationArea = All;

Caption = 'New Page per Vendor';

}

field(ExcludeVendorsWithBalance; ExcludeVendorsWithBalance)

{

ApplicationArea = All;

Caption = 'Exclude Vendors That Have A Balance Only';

}

}

}

}

}

// RK-end

var

RunningBalance: Decimal;

// RK-start

ShowAmountsInLCY: Boolean;

NewPagePerVendor: Boolean;

ExcludeVendorsWithBalance: Boolean;

// RK-end

}