Question
Murex
LB
Last activity: 12 Jan 2017 9:56 EST
Repeating Grid Reading from Data Page
Hello all,
I have a repeating grid with a data page as its source (which in its turn reads from a report definition). My problem is that the grid only loads 500 results from the data page (while there are around 4K results).
I've looked around but wasn't able to find any option or setting that would allow me to make the grid load all the results of the data page.
Any help would be greatly appreciated! :)
Thanks,
Joe
***Updated by moderator: Lochan to update Category***
Accepted Solution
PEG
IN
If you can flush the datapage, you should see all the results in clipboard as well as in repeat grid.
PEG
IN
Hi,
By default report definition returns 500 rows unless you change the value from Data Access tab. That could be the reason your grid is displaying 500 results.
Please run the report definition standalone and see how many records it is displaying.
Kindly refer https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
General Data Source Settings
You can enter settings for some of these options on the Designer Studio> Reporting > Settings landing page that will serve as defaults for all reports.
Hi,
By default report definition returns 500 rows unless you change the value from Data Access tab. That could be the reason your grid is displaying 500 results.
Please run the report definition standalone and see how many records it is displaying.
Kindly refer https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
General Data Source Settings
You can enter settings for some of these options on the Designer Studio> Reporting > Settings landing page that will serve as defaults for all reports.
Field |
Description |
| Maximum number of rows to retrieve |
Optional. Specify a maximum number of rows of results to retrieve for the report. As a best practice during testing, accept the default value If you exceed the established limit, the rows that have been retrieved are displayed, and the report header displays the total number of rows. No error dialog or error message display, and an error is not written to a log. When the Use Paging check box on the User Interactions tab is selected, this value is ignored (and not available). You can advance through pages with no limit. |
Murex
LB
Hello Gangababu,
Thanks for your reply.
I did change the settings of the report to retrieve up to 5000 records, and when I run the report I get all the results. Before I changed this setting, the report would retrieve all the results but when I tried to run the Data Page reading from it, I would only get 500 results.
Now, and after I changed the number of records that the report retrieves, both the Report and the Data Page retrieve all the results, but the grid that reads from that Data Page only shows 500.
Thanks,
Joe
Murex
LB
I get all the results. It's very weird as the Data Page on it's own returns all results as well. But it's not reflected in the Clipboard. I'm going to try and delete the Data Page and re-create it (or flush it from the Clipboard somehow).
On another note, when we enable Paging in a Report Definition, the system should ignore the max number of records to retrieve and should actually return all results. When I enable paging and run the report, this is indeed the case (I get all the results). But for the Data Page that is reading from that report, only 500 results are shown when I run that Data Page. I don't know if it's just my thinking or this is indeed an erroneous behavior.
Thank you for your help :)
Joe
Accepted Solution
PEG
IN
If you can flush the datapage, you should see all the results in clipboard as well as in repeat grid.
Pegasystems Inc.
IN
HI
There is no limitation at Repeat Grid level, In renders the what ever results are there in Clipboard
Can you check how many restults are there in clipboard ?