Post reply

SSRS 2010 Datepicker calendar is not displayed when a parameter has the available values setup

  • July 23, 2018 at 11:26 am

    #414428

    In a modifed ssrs 2010, I added a parameter called startdate where the data type is set to date/time.
    The start date parameter obtains its default value from the following query:
    select schoolyear,min(startdate)AS STARTDATE
     from [CampusOps].[dbo].[AtnLtrSemester]
     where schoolyear = @pSchoolYear
     group by schoolyear
    **Note the @pSchoolYear value is set to integer.
    The query runs fine when I only have a default value set and the value displayed looks like the following 07/27/2017.
    **Note the school year parameter also has a default value which is currently 2018.
    The problem is when the user wants to change the school year parameter to 2017. The start date problem does not change.
    To fix that issue, I have the available values set to dataset=startdate, value field=startdate, and label field=startdate.
    The problem is then the datepicker calendar option that I want the user to access is not displayed when the available values of a parameter are selected.
    Thus can you tell me what I can do to solve this issue?

  • July 30, 2018 at 8:41 am

    #1999487

    The moment you supply any "available values", you give up the date picker.   Even with later versions of SSRS, that remains true.  If your Default value is dependent on another parameter, then you need to use that parameter to the query or stored procedure that feeds the Default value and corrects that value accordingly.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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