I have a normal integer parameter to allow the user to select a preset date range like this
1, This Month
2, Last Month
3, This quarter
I have a table which for an DateRange of 1 has 2012-10-01 00:00:00.000 and 2012-10-31 00:00:00.000 as datefrom/dateto
The DateRange of 2 returns 2012-09-01 00:00:00.000 and 2012-09-30 00:00:00.000
The query for the dateFrom and dateTo is very basic
SELECT DateFrom, DateTo
WHERE DateRange = @DateRange
When I run the report, (no default for the preset choice parameter) and choose on of the preset values, then the date from and date to are populated correctly, but if I then change the preset value the date from/to do not change.
This technique works fine for normal varchar parameters, such as country with region but it seems either their is a bug in 2008R2 SSRS to do with DateTime parameters or I am getting something wrong.