Parameter - Add a Multi-Value Parameter - Copy.rdlx
3.5in
0.875in
0.125in
0.125in
6in
3
DataSet2
0.333333in
true
Product ID
true
Product Name
true
Supplier ID
true
Category ID
true
Quantity Per Unit
0.333333in
true
=Fields!ProductID.Value
true
=Fields!ProductName.Value
true
=Fields!SupplierID.Value
true
=Fields!CategoryID.Value
true
=Fields!QuantityPerUnit.Value
0.666667in
0.125in
1in
1.25in
1.125in
1.125in
1.25in
0.125in
5.75in
1
1in
1in
11in
8.5in
1in
1in
6.5in
String
Select the product names
1
true
DataSet1
productName
productName
provider=Microsoft.Jet.OLEDB.4.0;data source=L:\EvanWarren\ActiveReports\KnowledgeBaseArticles\ARD- How to add a multi value parameter to your report\C1NWind.mdb;persist security info=True;
OLEDB
productName
Select distinct productName from Products
DataSource1
ProductID
ProductName
SupplierID
CategoryID
QuantityPerUnit
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued
select products.*
from products
where ProductName in (?) or '1' in (?)
DataSource1
=Parameters!ReportParameter1.Value
=Parameters!ReportParameter1.Value