Forum Discussion
Report Builder - Ranking 2 most common entries in column
Hi everyone, This issue is making me insane and I can't figure it out. My 'Dataset5' contains a column with codes in it that are text and numbers like below: Names John5 Alice1 Rob...
If possible, doing the sort order in the query is most efficient. Or having the query return a computed number of occurances.
If you need to do that in the report, you might try either adding a group on name then showing the count in the group details. Or using something like LookupSet() -- https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-lookupset-function?view=sql-server-ver16