Report Definition Output
Hi,
I am working on Pega 6.3 and specifically in that I am working with Report Definitions.
After getting results using the report definition, It will always show as "Displaying 50 records" even when the no. of records is more than 50.
But when the records count is less than 50 then it displays the actual number. Only in the case when it is more than 50 it will write "Displaying 50 records"
How do I resolve this?
please help
Attaching Screenshot of the scenario where the no. of records is more than 50.
this false record count is also causing trouble when I export results to excel.
***Updated by moderator: Lochan to add Categories***
Pegasystems
IN
By default report definition has pagination enabled. Please disable pagination from the report definition rule to see all the records. Note that the number of records retrieved is governed by the maximum records to retrieve field in the report.
Pegasystems Inc.
IN
You can restrict the number of records retrieved by puting the desired value in maximum records to retrieve field in the report definition.
Pegasystems Inc.
US
The pagination settings can be found under the "User Interactions" tab and the Max row retrived can be found under "Data Access" tab.
While the pagination can be easily enabled / disabled. Max number of rows to retrieve may need a Dynamic system setting change. LEt us know whether the changes to pagination helped.
Coforge Ltd.
IN
Hi Krithigassree,
Yes I need to make it dynamic even for records count more than 500.
But I have no idea as to how to make it dynamic, as far as I know one section needs to be modified but how and where I dont know.
Thanks
Pegasystems Inc.
IN
Hi,
I believe the statement "Displaying 50 records" is concerning to that particular page where 50 records are being shown not regarding the entire report.
Export excel will export all the records in the RD, could you please let me know the exact issue you are facing with the count ?
Coforge Ltd.
IN
Hi Shashidhar,
Thank you for repyling
Actually when I run the report I get around 3000 records.
Now if I disable the Pagination, by default Pega sets it to 500. So on screen I get 500 records only and on the top it says "Displaying 500 records"
which is not the actual count.
When I export the same to excel it gives me 3000 records but on the top its says "Displaying 500 records", which is wrong.
I need to customize it, so that is what I want to know as to how to customize that section.
Pegasystems Inc.
IN
Check whether your pagination is enabled or not. if yes , check the page size and compare that with the no of data that is getting displayed and share the result
Coforge Ltd.
IN
Hi Santanu,
The number of records that will get populated is not fixed. Sometimes it can be 3000 and sometimes 2500.
Maximum no. of records at which I am restricting is 3000.
So if i set the page size to 3000 and suppose I get 2550 records also then at the top it will display "Displaying 3000 records"
In short in "Displaying xxxx records" , xxxx will always give the value at which I am setting the max page size.
But I want that to by dynamic.
Pegasystems
IN
Set the max records to 0 to get all records. Note that this may result in poor performance if the number of records qualifying the report criteria is huge.
Coforge Ltd.
IN
Hi,
Setting max records to 0 did not help.
Firstly as per the requirement max records should be 3000(Sorry I forgot to mention that in my requirement)
and the other thing is zif I set it to 0, by default Pega treats it as 500 and displays 500 records on screen but on export it will display the all the others records also(if it is more tha 500) but then also at the top it will be written as "Displayin 500 records" whereas I am having nearly 3000 records.
For record count less tham 500 it is working fine.
But as per the requirement I need it to be dynamic even for records count more than 500.
Pegasystems
IN
Setting max records to 0 did not help.
Firstly as per the requirement max records should be 3000(Sorry I forgot to mention that in my requirement)
I am little confused by this. If your requirement is to restrict the number of records to 3000, then max records should be set to 3000. Are you intending to do pagination but still restrict the total records across pages to 3000?
Coforge Ltd.
IN
Hi All,
Thank you for repyling
Actually when I run the report I get around 3000 records.
Now if I disable the Pagination, by default Pega sets it to 500. So on screen I get 500 records only and on the top it says "Displaying 500 records"
which is not the actual count.
When I export the same to excel it gives me 3000 records but on the top its says "Displaying 500 records", which is also wrong.
I need to customize it, so that is what I want to know as to how to customize that section.
Thanks in advance
C3i
IN
Hi Jannanankur,
How are you displaying records fetched by report definition, if you are using repeting grid check the pagination options available. If you have any OOTB option of changing the pagination formats try those options for your reuirement.
In Pega7, we have options of displaying it in different ways like page numbers, Rows <> of <> kind of. As I am not awre of options in Pega 6.3 could not give you exact option to choose.
Thanks,
Harsha A.