@ANUSHA cherukuri

Here’s the thing: pxTotalResultCount shows 500 because paging uses a capped estimate, not the real total. To get the true count with the same RD, call the RD once in “count-only” mode instead of a paged run: use pxRetrieveReportData (not pxRetrieveReportWithPaging), pass the same filters/parameters/Virtual RD inputs, set pyIsPageable = false and pyMaxRecords = 0 so no rows are fetched, and read pyReportContentPage.pxTotalResultCount for the exact COUNT(*). If you must stay inside the same RD, add one aggregation column with Function = COUNT on a unique field (e.g., pxInsHandle), run via pxRetrieveReportData, and read that value from the first result page. Avoid using the section’s paged data page for counts; it will keep returning 500. If distinct is required, enable “Remove duplicates” or count on a distinct column. Be mindful this executes an extra count query, so add an execution threshold or cache when the result set is large.