Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Devarajulu Prathapaneni (DevarajPrathapaneni) Swedbank AB Software engineer
Swedbank AB
SE
DevarajPrathapaneni Member since 2020 39 posts
Swedbank AB
Posted: Mar 29, 2019
Last activity: Nov 13, 2019
Posted: 29 Mar 2019 12:56 EDT
Last activity: 13 Nov 2019 10:47 EST
Closed

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.

To see attachments, please log in.
Dev/Designer Studio Reporting

Posted: 5 years ago
Posted: 25 Apr 2019 15:26 EDT
Devarajulu Prathapaneni (DevarajPrathapaneni) Swedbank AB Software engineer
Swedbank AB
SE

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

To see attachments, please log in.
Posted: 5 years ago
Posted: 26 Apr 2019 10:24 EDT
Shanthini Charles (ShanthiniC) Techmahindra
Techmahindra
IN

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

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 26 Apr 2019 11:21 EDT
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice