Post reply

possible to force @parameter value to refresh?

  • January 12, 2012 at 7:25 pm

    #253446

    Here's my problem

    I need to find a way to set a @datetime parameter based on the label,

    ie midnight today/current shift

    or find a way to get SSRS to refresh the @parameter.value from the dataset when no visible parameters are changed

    What's happening is I have an autorefreshing dashboard that's set to report current shift data.

    I'm using linked reports and passing in the 'label' of the time period i want to use to the base report. It cascades down to populate an internal datetime param that is used in the data dataset.

    But the internal @datetime parameter isn't refreshing to the new shift when the old shift ends.

    The dataset that populates the parameter is changing. But I'm fearing that ssrs doesn't see a need to refresh the contents of the cascading parameters because the value of the user selectable parameter selection isn't changing.

    Any tips?

  • January 12, 2012 at 7:49 pm

    #1432982

    Hmm.. I would probably pass a hidden Dashboard field that defaults to null or an empty string, and in the query feeding the subreport test for that value and replace it by the current date.

    If the user selects a different date, that value would be displayed and at the same time be assigned to the hidden field.

    In other words, I would disjoin the report from the displayed field.

  • January 12, 2012 at 8:36 pm

    #1432985

    I think that's similar to what will be my last resort..

    rewrite the SP that generates the report dataset to take a @Label parameter and have the sp query pull out the correct datetime for that label from my 'valid datetime parameters' reference view.

    I have 1 other think i want to try first though...

    But i find it somewhat strange that even if you something simple like create a report.

    add a parameter and assign Globals!ExecutionTime as its default.

    add a textbox and set its value to the parameter

    add another textbox and throw globals!ExecutionTime into it

    Refresh it a few seconds apart. the textbox with the parameter won't update.

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

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