Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, June 9, 2014 11:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:15 PM
Points: 150, Visits: 369
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
Post #1578911
Posted Tuesday, June 10, 2014 6:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:41 PM
Points: 6,134, Visits: 7,183
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