Get the most occured string

[Piku7]

Hi All,

I'm new to this forum, but I'm not totally green in reporting (I hope ).

I have a question. Imagine that I have a field in database where material names are stored. Example:

MATERIAL
Rubber
Steel
Steel
Wood
Rubber
Glass
Rubber

In the report header I would like to get a name of material that occurs the most times in that column.

Thank You in advance for Your help.

[Lech Kulikowski]

Hello,

You can use Grouping with Condition. Please check the sample report in the attachment.

Thank you.