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 02, 2013 1:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 08, 2013 3:19 PM
Points: 34, Visits: 157
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 03, 2013 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 256, Visits: 611
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 03, 2013 8:44 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, March 28, 2014 1:02 PM
Points: 150, Visits: 445
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 03, 2013 9:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 256, Visits: 611
Caught the mispelling after I posted the images. Fixed both issues and still get the comma error.
Post #1449272
Posted Friday, May 03, 2013 10:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 08, 2013 3:19 PM
Points: 34, Visits: 157
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