Post reply

SSAS + SSRS 2008 SET DEFAULT DATE / DATEPICKER

  • March 23, 2010 at 2:18 pm

    #222182

    LS,

    Is it possible to set the default value for a date-parameter in an SSRS report (using OLAP as a dataprovider) ?

    The date-parameter is of type date/time (when the user opens the report he can use the datepicker control to select the date). What I want is that the datepicker defaults with a specific date (Jan 1 2010).

    Does anyone know if this can be done and how ?

    Your help would be appreciated.

    Cees

  • March 24, 2010 at 3:21 pm

    #1139274

    Just figured it out my self. It can be done by using the VB command DateSerial. For instance, the following command results in the first date of the current month in the previous year:

    "=DateSerial(Year(Now)-1 ,Month(Now),1)"

    Cees

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

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