In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Is there an easy way to produce a Top 10, Top 100 or Top x report?
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.