How to validate report selections in Business Central

Recently I had to validate some filter selections on a report in Business Central and found out it was not so straight forward to do. What happened when using the trigger OnPreDataItem() or trigger OnPreReport() triggers was that I was able to validate the filter selections by user but the user experience was not optimal since the selection page closed when the validation error occured. What I came up with was using the trigger OnQueryClosePage(CloseAction: Action): Boolean trigger on the requestpage itself.

Published on: November 09, 2023

Learn more

Posts on Microsoft Dynamics 365 Business Central Development

Recent content in Posts on Microsoft Dynamics 365 Business Central Development

Dynamics 365 Business Central: How to check if the time zone supports daylight saving time (DST) via AL

Hi, Readers.Today I would like to share another mini tip about Business Central, how to check if the time zone supports daylight saving time (...

1 day ago

Dynamics 365 Business Central: Adding comments to Factbox/Report (Displaying Comments in a FactBox/Report)

Hi, Readers.Last week we briefly discussed how to add Notes (System Parts) from FactBox to a report. Later I received some feedback that it mi...

2 days ago

Dynamics 365 Business Central: How to add or subtract hours from a DateTime field

Hi, Readers.Today I would like to share another mini tip about Business Central, how to add or subtract hours from a DateTime field. Date...

3 days ago

Dynamics 365 Business Central: Analyzing performance issues using the page inspector

Hi, Readers.Today I would like to share another mini tip about Business Central, how to analyze performance issues using the page inspect...

4 days ago

Cumulative Update Summary for Microsoft Dynamics 365 Business Central (January, 2026)

Cumulative Update (January, 2026) for Microsoft Dynamics 365 Business Central is now released. BC27: CU03 Cloud (SaaS): Managing Production an...

5 days ago

Dynamics 365 Business Central: How to get the Month Name/Text from a date (Two ways)

Hi, Readers.Today I would like to share another mini tip about Business Central, how to get the Month Name/Text from a date. For example,...

8 days ago

Dynamics 365 Business Central: Add a Scan Barcode action and scan multiple/Continious scanning (Invoke barcode scanning programmatically from AL)

Hi, Readers.Today I would like to talk about how to add a Scan Barcode action and scan multiple/Continious scanning in Business Central S...

9 days ago

Blog image