Selecting all rows per page is not recommended for creating interactive reports unless the volume of data is less.
Run the report query in SQL develper or TOAD and note down the time take to execute. If it takes more time then you have to optimize query.
Between why do you need to select all rows per page?
Thanks for your reply.
Actually as per user point of view He wants to see Rows Per Page on his preference, sometimes he wants 100 rows or sometimes more. That's why I kept that option on that Page.
Is it some limit for Fetching Rows by sql query after which It throws error in interactive report.
Its not even working If I set the Rows per Page to 1000. Only in case of 100 Rows per Page it is working.
I am also using Apex_Items.Text in one of the column of the report to create text boxes at row level.