Home Forums Reporting Services SSRS 2012 saving variable from a stored proc RE: saving variable from a stored proc

  • September 28, 2017 at 3:39 pm

    #1961487

    sgmunson - Thursday, September 28, 2017 1:44 PM

    Okay, then what do you mean by "save" that parameter value?   Display it in the report?   You can create a textbox and have it's value be an expression that references any of the existing report parameters.

    The expression to do so would be (assuming your parameter is called "MyParameter"):
    =Parameters!MyParameter.Value
    or
    =Parameters!MyParameter.Label
    Depending on if you want to return the Value or the Label (surprise!) of the parameter.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk