How to show total count on default launch or changing the filter in report

Published on March 29, 2019 - 12:56pm

Last updated November 13, 2019 - 10:47am

Question

How to show total count on default launch or changing the filter in report

We have report definition on our work table which as almost 3M records. We have exposed this report to manager with some criteria.We have added customfilter criteria section in report definition. Wrote custom activity which will Call Rule-Obj-Report-Definition.pxShowReport OOTB activity to launch the report definition. We have invoked custom activity in open url in window control. So would like to show the total count available on initial load or when user apply filter to hide export excel option. Do we have any simple way to find total count of records.

Designer Studio

Reporting

Comments

Keep up to date on this post and subscribe to comments

Mahesh Midthuru

Pega

March 29, 2019 - 4:44pm

Hi Deva,

Will the pxResultCount property in pyReportContentPage satisfy your need?

Regards,

Mahesh M

Deva_Prathapaneni

March 29, 2019 - 5:00pm

Response to Mahesh Midthuru

Hi Nahesh,
Thanks for reply. No when pagination enabled it shows 50 only.

Thanks,
Deva

Mahesh Midthuru

Pega

April 1, 2019 - 2:10pm

Response to Deva_Prathapaneni

If you might have enabled the pagination in the report definition then you can use pyReportContentPage.pxTotalResultCount property.

Deva_Prathapaneni

April 25, 2019 - 3:26pm

Response to Mahesh Midthuru

Hi Mahesh,

In our case pxTotalResultcount showing 500 only when we have records more then 500. We need to enable any setting or DSS for this. I am implementing in 7.2.2

Thanks,

Deva

Shanthini_Charles

Pega

April 26, 2019 - 10:24am

Response to Deva_Prathapaneni

Hello Deva,

This property pxTotalResultcount is fetching 0 when pagination is not enabled, if enabled showing X*10 where X is the page size

In Report Viewer Paging Settings use Page Mode as Next Previous or Drop down instead of Numeric then the value in pxTotalResultcount will give correct results.

Attaching image for clear understanding.

Regards,

Shanthini Charles

Mahesh Midthuru

Pega

April 26, 2019 - 11:21am

Response to Shanthini_Charles

So based on the above explanation this seems to be an issue for the Page mode of type Numeric in the pagination settings, may be Deva can spin off SR if you are specifically using Page mode of type Numeric and other 2 options don't satisfy your need.