Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS with sp, should have same Paremeter Order or not? Expand / Collapse
Posted Monday, June 9, 2014 11:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:10 AM
Points: 254, Visits: 676
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

Post #1578911
Posted Tuesday, June 10, 2014 6:55 PM



Group: General Forum Members
Last Login: Wednesday, September 23, 2015 3:34 PM
Points: 5,467, Visits: 7,660
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1579453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse