I've got two parameters on my report titled "CustName" and
"OrderID"...both are in the Details section...however, only one
parameter works, the other doesn't...
sample code:
Dim param1 As New ParameterField
Dim param2 as New ParameterField
Dim paramValue As New ParameterDiscreteValue
(tbCustomers is set to a datatable which is filtered to contain 1
record)
(tbOrders is set to a datatable which is filtered to contain all orders
for customer in tbCustomers)
param1.ParameterFieldName = "CustName"
paramValue.Value = tbCustomers.Rows(0).Item("FullName")
param1.CurrentValues.Add(paramValue)
param2.ParameterFieldValue = "OrderID"
paramValue.Value = ??? (need all OrderID's from tbOrders)
param2.CurrentValues.Add(paramValue)
param1 works because it is set to a specific field in a table.
however, I'm not sure how to assign the value of param2, since there
will be several results.
thanks...