Suppress Duplicate Rows On Grid

[edwardkch24]

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.

Thanks.

Regards,
Edward Kok

 

[Frosty the Coder]

In the event Grid Record is Fetched:

If BC_control_column is equal to VA FRM_control_column
Suppress Grid Row
Endif.
VA FRM_control_column = BC_control_column.

 

[edwardkch24]

Hi Frosty,

Thanks for the advice. Appreciate that.

Thanks
Regards
Edmamba24

 

[johndanter]

Frosty is bang on.

...assuming the grid is sequenced accordingly

 

[llallen1113]

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.

 

[saikiran]

Select distinct feature when designing the business view