Post reply

SSRS Parameter Controlled Drill down

  • December 10, 2013 at 11:55 am

    #281015

    Hi,

    I have a SSRS report which has a Drill-Down via our Date Dimension, and

    shows a measure at the year, quarter, or month level :

    Year (+)

    Expands to

    Year (-)

    Quarter(+)

    Expands to

    Year (-)

    Quarter(-)

    Month

    My question : Is it possible to control how the Drill Down expands via a parameter? We have customers who want the report (via subscription)

    delivered at the year level, and some customers who want the report delivered (via subscription) at the month level.

    Please and thanks!

    The Hurricane

  • December 11, 2013 at 12:31 pm

    #1672731

    You could perhaps try using an expression in Properties -> InitialtoggleState (near the bottom) for this report item, something like =IIF(Parameters!Month.Value = 1, False, True).

    Doug

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

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