Couple of answers:
If you want to generate a report using Microsoft Reporting Service, then you can refer MSDN article for step by step tutorial at
http://msdn.microsoft.com/en-us/library/ms159170(v=sql.100).aspx[
^]
To find data from a table in between two dates, you can use the below SQL query:
SELECT *
FROM @Orders
WHERE Orderdate
BETWEEN @Startdate AND @Enddate