Question
Infosys
IN
Last activity: 26 Nov 2021 7:11 EST
How to increase count of result on Table Layout
Hi ALL,
I have customized an activity,in which I have called two report definitions.and copying data from second pagelist to 1st using Page-Copy method.Now I have given this Pagelist 1 as source to Table Layout.Now based on date range i am displaying results on UI.But result count from both the reports after combining data as well is very low.Max I am getting 150 records only. But there are more number of records present in these reports.
How can I increase this result count?
Accepted Solution
Infosys
IN
Hi All,
So I have disabled the pagination for both the reports and increased their maximum count.Now after calling these reports in an activity,I am getting all the records from both reports and this solved my issue.Now Pagination is only there on Table Layout.
Thanks all for your help.
Pegasystems Inc.
ES
@VinayMalkar without knowing the whole context, i would say you can check:
- The number of rows retrieved by the report definition.
- The number of rows displayed by the table (do you have pagination enabled?)
- Is the report returning all the rows if you run manually?
Hope this helps.
Infosys
IN
Hi @VEIGI, Actually we are having business requirement so that user wants to run a single report based on date range.To accomplish this,We have clubbed two reports in an activity and displayed the results from activity on UI using Table Layout.
We have followed this approach because both reports are in different db.So can't use joins as well.
If I run both reports separately, count is more.
Pagination is enabled.but when I results from both count is very low
Pegasystems Inc.
ES
@VinayMalkar what i can suggest is:
In the activity
- Run the first report and add the results in an temporary page.
- Run the second report and add the results in the same temporary page.
- Use the temporary page as source for the table.
You can try this way and confirm if the records are then as expected.
Aaseya IT Solutions
IN
@VinayDnyaneshwarMI am not sure if the approach you are following is correct.
What are the counts when you are running the reports independently ?
Infosys
IN
Hi @Raju_Botu, If I run these reports separately, count is more
But after clubbing toghether, I am getting less number of records
Accepted Solution
Infosys
IN
Hi All,
So I have disabled the pagination for both the reports and increased their maximum count.Now after calling these reports in an activity,I am getting all the records from both reports and this solved my issue.Now Pagination is only there on Table Layout.
Thanks all for your help.