By using this website, you agree to our Terms of Use (click here)
All I can think of doing is creating a variable and counting up the groups and hopefully sort the groups by value so I can use visible expression to hide after the top 10.
SELECT TOP 10 or using the windowing functions like DENSE_RANK would be really handy at times like this!
Can't use a view and create DAC for it due to MySQL being a bit pants when there's an aggregation or any number of useful things in the view (it sticks the whole thing to temp table on disk and then queries against it which is not great the more rows you have).
Using a Variable is the only thing that I can think of at the moment as well. In the future, Report Designer is going to a Generic Inquiry as a data source and a Generic Inquiry can do TOP so that might be a cleaner way to do this in the future.