Report displays wrong information when moved to the next page

<p>Hello All</p><p>I have designed a report connecting to a view at design time. The sql for the view is </p><p>select * from table</p><p>I am passing a recordset at runtime to the report using a sql query which takes couple of parameters</p><p>select * from table where date between date1 and date2</p><p>when the report is displayed the 1st page shows the correct information. When i click on the arrow to show the next page the report displays all the records which were seen at design time. I am not sure how to rectify this problem.</p><p>Thanks</p><p>Ram</p>