Hello there, I have recently started using SQL Server Reporting services. I currently have a problem.
I am trying to achieve a search by dates in a report.
I have a table with the fields RequestDate in e.g. 22-Jan-2010 or 23-Sep-2010
I have created a report in Query Designer with two parameters in it RequestDate & RequestDate2.
The Operators are for RequestDate is: Is more than or equal to
The value is: 1-Jan-2010
And the Operator for RequestDate2 is: Is less than or equal to.
The value is 30-Dec-2010
When i go to the SQL Statement this is produced:
MHRA.RequestDate >= @RequestDate
AND MHRA.RequestDate <= @RequestDate2
When i go to view report i want to be able to search for dates between the dates 1 Jan 2010 and 30-Aug-2010
My query seems to pick up all or most of the results between these dates.
How can i build this query so i can get specific results. For example...in the Request Date Parameter box i would put 2-feb-2010 and in Request Date 2 i would put in 5-Jun-2010 and this would return all the results between these dates.
View Complete Post