web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Filter page for a report

Business Central forum

Filter page for a report

(0) Share

Report

Report

Posted on by Dynamics 365 Busine...

700

Hi All,

I have to create a new report in Business Central, by applying certain filters, for example Employeee No., Location etc.

How to apply these filters, how to create that filter page.

Any AL code example to achieve this purpose!

Thanks in advance!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Avinash B 1,455 on at

Like (0)

Report

Hi

You can use RequestFilterFields for this purpose. You must define the fields that you want to view on the request page.

Otherwise, define the global variable and use them in the request page. On OnPreDataItem, use these variable to filter the data item.

References:

docs.microsoft.com/.../request-pages

Regards

Avinash B

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You need to specify like below

dataitem("Employee Absence"; "Employee Absence")
{
DataItemTableView = SORTING("Cause of Absence Code", "From Date");
RequestFilterFields = "Employee No.", "From Date", "Cause of Absence Code";

If you want to run the report using code with filters set , then you need to specify those filter on the actual record and then pass that to the report, an example below

ItemJnlLine.SetRange("Journal Template Name", "Journal Template Name");
ItemJnlLine.SetRange("Journal Batch Name", "Journal Batch Name");
REPORT.RunModal(REPORT::"Inventory Movement", true, true, ItemJnlLine);

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans