In my main report I prompt the user to enter 1 or more budget groups (call this parameter
{?BudgetGroupList}). The main report lists various totals for the specified budget groups. In the report footer I have a subreport that lists totals for each budget sub-group contained in the requested budget groups.
The issue: The subreport is linked to the main report via {?BudgetGroupList}. The linked value is used in the subreport's selection criteria (like: if {budgetgroup} in {?Pm-?BudgetGroupList} )
The subreport only displays data from the first element in the array. When there are two or more values, the later elements are ignored. I have changed the selection to use the parameter as a range... Now I get all of the budget groups between and including the first and last elements in the array; so the subreport is getting the full array. I'd rather just see data for the budget groups selected by the user. Any ideas?
{?BudgetGroupList}). The main report lists various totals for the specified budget groups. In the report footer I have a subreport that lists totals for each budget sub-group contained in the requested budget groups.
The issue: The subreport is linked to the main report via {?BudgetGroupList}. The linked value is used in the subreport's selection criteria (like: if {budgetgroup} in {?Pm-?BudgetGroupList} )
The subreport only displays data from the first element in the array. When there are two or more values, the later elements are ignored. I have changed the selection to use the parameter as a range... Now I get all of the budget groups between and including the first and last elements in the array; so the subreport is getting the full array. I'd rather just see data for the budget groups selected by the user. Any ideas?