Calendar Control in SSRS

  • Hello everyone,

    I am working on a report that requires to to use calendar control, thus allowing users to pick the date range that they'd like to run the report.

    The thing is I want to have a way to control this calendar control by using some kinds of conditional controls that it can either show up on the paramter list or be disabled that users can't select a date when it meets certains conditions.

    For example, if a user wants to execute the report a parameter on the report to show data for USA, then the calendar control is either not showing at all or disabled that user can do choose a date from it.

    Is there a way to accomplish this?

    Thank you so much for your help!

  • Though I am quite fresh in the programming field, but I've heard that there are UI calendar control, and there are tutorials for the calendar, I conceive your problem is not so hard to solve.

  • Make use of parameters for a start and end date, or a date as a single value, depending on your requirements.

    Add a parameter as Date/Time Type, Set the Default Value to =Today() or any date you wish to set as the default start date/date.

    Change your dataset query to use this parameter eg. where Date = @Date.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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