still problem with crystal report

why dont u try it by writing a stored procedure.. see its like when u have to filter some thing from data base we have to give where clause n all.. so do one thing write a sto. proc like this n just bind it wit ur crystal report.
create proc testCR
@OrderNo as nvarchar(50)
as
select * from tablename where OrderNo= @OrderNo and date between given two dates