I am writing derived tables and when i run the query in SQL server 2005 it returns 95000 rows but when i do a count all in the report that is generated it is showing 3700 rows only…I have set the result set size to 1 lakh rows…but its showing only 3700 rows…what do i need to do…please guide me.