Get the most occured string
Posted: Mon Mar 23, 2020 4:54 pm
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.
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.