Hi - Can you please clarify how paging works in report definition? If there are 10000 rows in a table and RD criteria satisfies for all the rows and if paging is enabled with page size 10 then every time the RD is called only 10 rows will be fetched from the DB or it will bring all the rows but in the screen only 10 rows will be shown at a time?
Thanks in Advance.
***Updated by moderator: Lochan to add Categories***
Hi Evita- thank you so much for your reply, just to confirm if we don’t use “Maximum number of rows to retrieve option” in the report definition and go for paging then from db end RD will fetch all the data (matched by where condition)first and create the clipboard pages as per page size say 20 per page, am I correct? In other words simple paging without “Maximum number of rows to retrieve option” dose not restrict no of rows to fetch. Kindly confirm this.
Thanks Evita but my question was if we use paging with 20 items per page will it fetch all the data from db end first then create clipboard pages with 20 items per page ? Just wanted to know with paging option enabled if it will bring all the data from db end first or not.