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 ««12

Parameter Alias Expand / Collapse
Author
Message
Posted Thursday, May 2, 2013 1:41 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 4, 2016 3:30 AM
Points: 156, Visits: 347
Maybe the parameter type is not correct ?
Can you post all the screenshot of the parameter configuration please
And the table definition
Thanks


!!!GOOGLE IS YOUR BEST FRIEND!!!
Post #1448966
Posted Friday, May 3, 2013 8:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 5, 2016 2:00 PM
Points: 315, Visits: 960
Here are the screen shots.

STATUS IN (@Status) --('4','10','30')



  Post Attachments 
General.PNG (4 views, 30.90 KB)
Available Values.PNG (3 views, 31.37 KB)
Post #1449222
Posted Friday, May 3, 2013 8:44 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, July 21, 2016 9:25 AM
Points: 176, Visits: 543
The parameter name is misspelled as "Stauts," which could be the main issue. Also, if the original status values are integers, then you should change the Data type of the parameter to integer as well, so that no implicit conversion needs to take place in the comparison operation.
Post #1449245
Posted Friday, May 3, 2013 9:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 5, 2016 2:00 PM
Points: 315, Visits: 960
Caught the mispelling after I posted the images. Fixed both issues and still get the comma error.
Post #1449272
Posted Friday, May 3, 2013 10:13 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 4, 2016 3:30 AM
Points: 156, Visits: 347
can you repost all the dataset and the query using this parameter ?
is the parameter used on a data region in the report ?


!!!GOOGLE IS YOUR BEST FRIEND!!!
Post #1449284
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse