How to limit number of records to show in list in report in Dashboard?

[Sravani Tammana]

Hi all,

I added a report to dashboard which contains a list of records, can somebody help me to show only 5 records only at a time in Dashboard i.e. pagination to show at a  time 5 record only in dashboard only not on globally.

Thank you

[Tracy Davis]

You can limit the number or records displayed in PA (on some types of widget views), but not for a report unfortunately

[Khozema Attar1]

Hello Sravani,

You can limit the records to display in the list view of the table on which report is created that will be reflected in the report on the dashboard.

Let's say the report is written on incident table, then on the incident.list, show only 20 records per page that will be reflected in the report as well.

I think the least count that you can give is 10 rows per page and not less than that so your report would show 10 records on the dashboard for that page.

However this is a user preference and you might have to create a user preference for all the users of the system to show only 10 records in list view.

Hope it helps.

Mark as helpful or correct.

Regards,

Khozema

[Christine Mayf2]

I wanted to achieve the same, but found the below (you can only do this with PA, not reporting) helpful response below to still be true (2024). But I needed a report to show the top ten list of records (based on a 'percentage' field in the records), so I added a new true/false 'Top 10'  field to the record, readonly, default is 'false.' I created a scheduled job to nightly sort all the records in descending order based on the 'percentage' and then iterate through, setting the first 10 records 'Top 10' value to true and setting all the rest to false. Not a real time report, but for top 10, this fit the bill for me. Besides, you could always drill down into the report and go to the list, sort by 'percentage' and easily see real time data if needed.