I am using Rank column in filter condition to get the first 1000 records. But reports displaying 1- 25 records only.
Please suggest me a solution.
Please post the Sql or the formula. It is hard to answer without more specifics.
In Results tab use icon with label xyz and then in style tab
select Content Paging radio button and then set number at 'Rows per Page'
mark as correct