Filtered Field in Report Request Page Based on Custom Criteria in Business Central
Sometimes, you may have a requirement to add a custom filter on the request page of a report. For example, if the user selects a specific field, the report should only show data where the values in that field start with "Abc". Only when the user selects this filter should the data in the report be filtered accordingly. I have created a custom customer report. For the Location Code field, I have set a condition to filter the data: only records where the Location Code starts with "ABC" should be available for filtering. When the user selects this field on the request page, only the filtered data (i.e., Location Codes starting with "ABC") should appear in the lookup. Once the user selects a value, the report should display data based on this filtered selection. Code: report 50710 Customerr { UsageCategory = ReportsAndAnalysis; ApplicationArea = All; Caption = 'Customer Report'; DefaultRenderingLayout = LayoutName; dataset { ...