SSRS with sp, should have same Paremeter Order or not?

  • HI, all

    Just want to confirm do I need to care that my rdl param list should correspond to order of params in the sp? aka be positional (in the order they displayed in the Paremeter list in rdl?

    Or they still work by their names ?

    because when you run sp with parametes order is critical I think unless you specify names of param explicitly ? And I mean paremeters which are completely isolated from each other, no any dependencies exist for them

    Best

    mario

  • mario17 (6/9/2014)


    Or they still work by their names ?

    This is correct.

    The names should correspond to parameters fed in your Data Source. Their screen position and/or order in the list shouldn't matter.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

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

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