Have you used the parameters in the record selection formula? e.g.
{table.date} in (?BeginDate) to (?EndDate)