Hello. I have a report definition rule to get some rows. There is a max quantity of retrieved values is 500 and a pagination was turned on in the report definition. I would like to know how to get an amount of all existed elements in a DB.

After some researching I've got some info about pxResultsCount and pxTotalResultsCount. But pxResultcount is limited by the report-side pagination, but after I have turned off a pagination, it got limited by a 'Maximum number of rows to retrieve"=500

Tell me please how to get total number of elements avoiding all limitations? Thank you.

***Updated by moderator: Lochan to add Categories***