Yeah. That is fine. we can change the max rows limit. but my requirement is for table selection in ad hoc view designer for sample data selection will display 15 records by default. but query will generate with limit as max rows value that is 200001 which we configured. but for cross tab, we will get limit as 1000 in query generator. same I would want for table also. Thanks, Sanjay