Post reply

Display parameters in the page header for the child report

  • March 30, 2011 at 2:24 pm

    #237059

    Hi ,

    Iam working on drill - through reports . The reports have 3 cascading multi- valued parameters.

    Country

    State

    City

    All the parameters have available & default values from respective stored procs.

    The State parameter have StateID as Value

    and State Name as Label.

    In the parent report in the header iam using Parameters!ParamState.LAbel .. and thats working fine

    The child report does not have any available or default values for the parameters.

    when Iam passing 3 param's to child report the State ID's are being passed to state parameter.

    My problem is How can I show the corresponding Statename in the header .

    All your help is appreciated !

    TIA

  • March 31, 2011 at 7:34 am

    #1305963

    Either put a query in your destination that will return the state name to a state name parameter based upon the state value passed to the state parameter, or pass the state name (label) from your parent report to a state name parameter in the child. Then use the state name parameter in the child in your header.

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

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