How to increase count of result on Table Layout

User Experience
, ,
1

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?

2

@VinayDnyaneshwarM 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.

3

@VinayDnyaneshwarMI am not sure if the approach you are following is correct.

What are the counts when you are running the reports independently ?

4

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

5

Hi @Raju_Botu, If I run these reports separately, count is more

But after clubbing toghether, I am getting less number of records

6

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.

7

@VinayDnyaneshwarM 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.