Hi all,

I just want to know how to add a todate,fromdate filter to a crystal report???

I add it in the parameter field But I donno How to relate the todate and from date to the actual date.

EG: I have emp table with empname,number,sal,hiredate

I want to see the details of the employee hired between (todate,from date) ????? Help me out. 

 Hi,

go to Report ->  Select Expert. In the Choose Field dialog, select employee.HireDate. Click OK. In the drop down on the next form Select Expert choose Is Between. Two more dopr-down will appear. Select your ?StartingDate parameter in the first one and ?EndDate parameter in the second one. Click OK. That should be it.

 You could also have a stored procedure that would accept StartDate and EndDate parameters and do the filter on the DB server instead.