asked
ssrs - date
in a parameter i am keeping value as 'before feb 2010' and 'after feb 2010', suppose if i select first value, it should show me the records which are before feb 2010 and for second option it should show me after feb 2010 reocrds.
If you simply mean that you want a parameter to have two options a label of 'Before Feb 2010' and another of 'After Feb 2010' you simply need to set the value to be the date (I am guessing if I say 01-feb-2010) and then use that parameter value in your stored procedure to filter the record set as you need it to. Having the split on the whole month is a bit ambiguous for your users - do you mean 1st of month or last of month? I would always recommend stating an exact date.
