Post reply

SSRS 2008 Date Picker - can it show specific values only

  • January 27, 2011 at 10:51 am

    #232891

    Hello,

    I am using SSRS 2008 which has a cool feature to show a small date picker option for 'Date/Time" parameter.

    I have a requirement where this date picker should only allow certain dates to be selected.

    Is it possible to show this dates as highlighted and other dates should not be allowed to be selected.

    Thank you

    AR

  • January 27, 2011 at 11:14 am

    #1279254

    Set your parameter to get available values from a query.

  • January 27, 2011 at 11:33 am

    #1279268

    Thanks you for your reply.. but

    I did do that and this takes away the Date picker (small calender) next to the parameter input textbox and converts it to a drop down list of the available values.

    Here are some details:

    Parameter - @Date

    Data Type - Date/Time

    now if I dont have any Available values set it shows me the Date Picker (calender)

    but if I provide the needed dates in a query form (select dates from datetable) it becomes a dropdown list of all the dates and removes the Date Picker.

    Any other suggestions

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply