Good idea, I have notw tried that and have displayed the parameters onto the report and they match the paremeter section, which means that after the initial selection they are not getting changed.

To recap:

I have a table with Date From and Date To fields, and an ID field which equates to the Prest Option

A parameter with options 1) This Month or 2) Last Month etc. These id's match the preset date table.

Upon selecting this ID then the date from date to paramters should change to use these preset values, so If I choose 'Last Month' then a value of 2 is used like this

The query for the dateFrom and dateTo is very basic

SELECT DateFrom, DateTo

FROM PresetDateRanges

WHERE DateRange = @DateRange --@DateRange is 2

As there is no default value, this works fine for the initial user selection, but if they want to change their mind and change the drop down list, then this does not perform the query again. This seems to only happen with date time parameters

In BIDS, the parameter section is re-drawn but no DB activity is performed.