Author Topic: Expanding sortable columns to full results, OR showing all results on one page (Read 778 times)

CiviTeacher.com · December 31, 2010, 04:52:42 pm

I have a report that generates a couple thousand rows of results. The default behavior of CiviReport appears to be 50 results per page. The sortable column headers (the little arrows) only seem to sort the results on the current page, not the entire result set.

I wish to be able to sort ALL the results with the column header arrows. Am I doing something wrong? Have I missed something obvious?

I see that I could accomplish my goal in one of two ways:

1. Change the behavior of the sort arrows so they sort the entire results.
2. Display all 2000 results on a single page

Whatever is easiest works for me. Any advice? Thanks!

CiviTeacher.com · January 03, 2011, 06:26:43 pm

Just as a follow up, in CRM/Report/Form.php I found a constant of 50 for the rows per page. Excitedly I increased this value, and propmptly reloaded the page, only to find my browser bogged down and crashed. Any value more than 200 (in my experience) is completely unmanageable. It's a shame that jQuery brings us so many good things, only to restrict our reports row counts because the script can't handle the data and crashes Firefox. Doing my full-result sorting via CSV in Excel makes me feel melancholy.

line 41 (or thereabouts)

Code: [Select]

    const  
        ROW_COUNT_LIMIT = 50;

CiviCRM Community Forums (archive)

News:

Author Topic: Expanding sortable columns to full results, OR showing all results on one page (Read 778 times)

CiviTeacher.com

Expanding sortable columns to full results, OR showing all results on one page

CiviTeacher.com

Re: Expanding sortable columns to full results, OR showing all results on one page