Select number of rows from DDL in crystal report

So you need to apply Paging in CR

0

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.

0

Manish Tewatia15y ago

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/

0

Suthish Nair15y ago

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

0