Question
3
Replies
829
Views
Posted: September 24, 2018
Last activity: October 11, 2018
Closed
Solved
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
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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