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.

Comments

Keep up to date on this post and subscribe to comments

March 29, 2019 - 4:44pm

Hi Deva,

Will the pxResultCount property in pyReportContentPage satisfy your need?

Regards,

Mahesh M

March 29, 2019 - 5:00pm
Response to Mahesh Midthuru

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

Thanks,
Deva

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.

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

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

 

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.

April 27, 2019 - 4:07am
Response to Mahesh Midthuru

Hi Mahesh, Shanthini,

Thanks for your help. I will check with business. If required number format only then raise SR.

Thanks,

Deva

April 29, 2019 - 8:45am
Response to Deva_Prathapaneni

Hi @Deva_Prathapaneni!

Please let us know the SR ID should you open a Support Request so that we may track it for you!

Thanks!

Marissa | Community Moderator | Pegasystems Inc.

November 13, 2019 - 10:47am
Response to Shanthini_Charles

Hello Shanthini_Charles,

Can we have the same functionality for a Data Page that reads from report definition?

Currently the data page is always fetching 0 for the value of pxTotalResultcount.

Thanks,

Mariane