Posted: 15 May 2017 11:47 EDT Last activity: 30 May 2017 9:34 EDT
Display Count of Records feature in report definition
List view rule has the option of showing total number of records (based on the where clause) if "Display Count of Records" check box is checked. How can I achieve the same functionality with report definition rules (opened from report browser)?
***Updated by moderator: Lochan to add Categories***
If you are executing the report definition, please use pxRetrieveReportData and not pxCallRetrieveReportData. pxCallRetrieveReportData activity is internally used by Data pages which use report definition as a source.
The record count for a report definition should be available in pxResultCount property in the output page of the report definition.
Thanks for your response. Here are two problems with pxResultCount property.
1. I am not showing the result of report definition in a section where I can use that property to show the total result count. The reports are opened from report browser. So we have the OOTB ui for presenting the report result. If we want to add a custom view that means we would need to have custom filter. We don't want to use custom filter for all the reports so far created as filter is not the problem.
2. pxResultCount would show the total count of the report def result. So if the max count is 500 and I have 550 records in DB for the same where clause in report def rule, pxResultCount would show 500. Our requirement is to show 550 as the number. That way the business user would know to select additional filter conditions to have smaller result set. I believe list view used to have that capability.