Limiting results to top 5
Hi,
I want to limit the amount of results that the report definition pulls by the top 5 columns that result the most (ex. Top 5 fast food restaurants that sold the most burgers instead of displaying stats for all fast food restaurants) because in the picture provided, there are a lot of results that produce no results and can be omitted. Can someone be of aid?
Thanks
Posted: 2 years ago
Posted: 2 years ago
Hi Aniket!
I would like to display the chart in a section rule. How would you filter the top 5 using a data page?
Accepted Solution
Posted: 2 years ago
Its as simple as going to the RD > Data Access > In the "Maximum number of rows to retrieve" field under "General data access settings', specify 5 to only get 5 rows displayed.
Do you want to show it in a report browser or section data grid.
If its not in report browser then you can use a data page and filter first 5 results in data page post processing.
For report browser you can try using 'Display Top ranked X rows Overall based on 'XXXX' option. This is at the very bottom of the Query tab. I know this works for a normal report but need to check for a summary chart.
Other option is to try to filter out rows which are having 0 count using sub report.
Regards,
Aniket