I have a drop down multivalued parameter. the items in this parameter must be hard coded and not coming from a dataabase.
how can this be done?
I want to hide the 'Select All' which is placed by default when you select multivalued parameter. How can this be done?
when I send it to stored procedure, I need to check an Enddate column.
if enddate is less than today then set columnX to 'currentFriday' otherwise to next friday.
I need to do it within the query.
Thanks in advance