E
Eych
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...
"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...