Select number of rows from DDL in crystal report

Question

Hi all ...

I have a requirement in my web page,I have a drop down list with values like 5,10,15...on selecting the value those many records should be displayed per page.

e.g if I select 5 it should show 5 records per page.

Suthish Nair · Answer

So you need to apply Paging in CR

vishal sahani · Answer

hi suthish according to youit will only show the reords betn those condition but i want to display all the records but 5 records or 10 records per page depending on the number of records selected by the user.

Manish Tewatia · Answer

Hi vishal check this link I am sure it will help help you...... https://pankajlalwani.wordpress.com/tag/number-of-records-per-page-in-crystal-report/

Suthish Nair · Answer

refer an sample sql query and work on it.. with cte as ( select row_number() over(order by sno) rn t.* from testtable t ) select * from cte where rn between 55 and 65