Suppress Duplicate Rows On Grid


Active Member
Hi All,

Would like to ask is there anyway to supress gridlines with same sets of data? Appreciate if anyone can share the code on how to do this. Not sure on how and where to set the event rules as well.


Edward Kok

Frosty the Coder

Legendary Poster
In the event Grid Record is Fetched:

If BC_control_column is equal to VA FRM_control_column
Suppress Grid Row
VA FRM_control_column = BC_control_column.
Discover how to build no-code data integrations and business process automations.


Well Known Member
Also, depending on the business view and your application requirements, you might be able to filter duplicates by selecting "distinct mode" on your business view. This would eliminate ER programming in the application.