Post reply

Data Driven Subscription - Override default parameter with an expression

  • March 15, 2017 at 8:30 am

    #336063

    I have a report with Month Parameter and has a default value Expression of = Month(Now). I want to create a data driven subscription that will override the Month Parameter to this expression =Month(DateAdd("M",-1,Now)). How do i do this? These are the three selection option 1.Use a report default value    2.Override report default value with static value    3. Override a report default value with value from database . None of them has the option of adding an expression.
    Thanks in advance.

  • March 15, 2017 at 11:42 am

    #1933305

    I found a solution 🙂 I added this query under the Query Section "Select Month(Getdate()) -1 as LastMonth" which will give me the last month then selected the third option Override a report default value with value from database then selected the field i created in the Query which is LastMonth.. Now my subscriptions works perfect!!! 😛

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

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