u can do it very easily by 2 types
1 use a stored proc then take date or anything u want as a parameter
2 put query on the basis of condition, like put 2 date time picker on your Reports and then select starting and ending then get difference , then put them to ur query, u will got ur record
If you get Help , then plz mark as helpful Reply