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 ?
