Posted: 2 Dec 2015 5:00 EST Last activity: 18 Dec 2015 0:24 EST
Custom value for record counter in repeat grid
Custom value for record counter in repeat grid.
Section with repeat grid layout, filled by report definition. It has huge amount of records (2000 for example), and pagination enabled (50 records on page) in layout options. Records combined to groups (for example, 40 in first group, and 120 for secons). On first page it shows 40 records for first group, and 10 for second.
Problem with record counter in repeat grid. It shows 10 records for second group (that is correct for current page), but we need to show total amount of records for this group (120 instead of 10). How to calculate and display this amount on record counter, when it divided on different pages?
In report definition properties (report viewer tab) marked "Group results and display values in sort columns 1 - 2 as group headings". Also in column properties for repeat grid marked "Categorize by this column". With this changes, results that are displayed, also grouped. And amount of records in group less than TotalResultCount.
Problem (if it can be called) occures, when in group we have more records, than displayed by single page. As I described before, 50 records per page, and smth like 120 records in group. We need to show real number of records (I mean record counter above the group of records, on the screenshot), even when part of them could be displayed.
I can't find the property, that stores amount of records in group. Also report results in clipboard only for current page, any ideas how to store the rest of results without losing pagination?