still problem with crystal report

Question

good evening  rekha mam  i am using a table which field are CustomerNo OrderNo StartDate ....... .and make a crystal report to chossing these field in crystal reports and then declare three Parameters which are @FromDate  @ToDate@Order in crystal report i want to display these parameters in aspx1 and crystal report on aspx2  in aspx1 i am using two datepicker control one Dropdownlist and one Button control aspx2 have crystal report viewer control . i want simply put my filter page aspx separate from crystal report page when i click button then aspx2 display the report.... i am not using stored procedure...simple crystal report parameters please help me ......

Rekha Singh · Answer

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