Question
Customertimes
LV
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?
P.S. Pagination is mandatory.
Pegasystems Inc.
IN
Hi
Consider using pyTotalResultCount property in your section. This is the total number of results returned by the query up to pyMaxRecords.
Customertimes
LV
Hello!
TotalResultCount show total number of results, I need to know number of results in group of records. It's different.
Pegasystems Inc.
IN
Hi Alexander,
I am sorry , but I am little confused with the actual requirement here !
The screenshot you provided ,made me feel that you are looking for something which is achievable via pxTotalResultCount.
Can you please explain a little about how you are doing the grouping ? Or how you are splitting the data inside a grid ?
Customertimes
LV
Hi, Santanu!
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?