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

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

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Maybe the parameter type is not correct ?
Can you post all the screenshot of the parameter configuration please
And the table definition
Thanks
Post #1448966
Posted Friday, May 3, 2013 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 3:24 PM
Points: 266, Visits: 692
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, August 21, 2014 7:49 PM
Points: 171, Visits: 501
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 3:24 PM
Points: 266, Visits: 692
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 Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
can you repost all the dataset and the query using this parameter ?
is the parameter used on a data region in the report ?
Post #1449284
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse