none
TSQL "IN" in CommandText RRS feed

  • Question

  • Hi

    I using ReportViewer 9.0.0 , how Do I set an "IN" in the DataSet CommandText.

    Our table data consist of type column which has (1 to 5 status value). Our user can select which status he want to see in the report.
    They can choose one or multiple status, so in the sql command I need to use IN like below

    SELECT * FROM customers WHERE ( createdate = ? ) and status IN ( 1,2,5 ) -> I need to change this to dynamic input

    But when I write 

    SELECT * FROM customers WHERE ( createdate = ? ) and status IN ( ? )

    It doesn't work and keep refuse the input . The status column is using datatype int.

    Is it possible ?

    Friday, May 18, 2012 6:07 AM