Posted: 14 Nov 2016 5:16 EST Last activity: 18 Nov 2016 10:44 EST
Report Definition Output
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?
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***
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.
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.
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?
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.