Set Parameter error "...only accepts a single value" using a data source with delimited values
Bryan Baca
started a topic
over 5 years ago
A BusinessObjects document contains an EQUAL TO parameter. The parameter value is supplied from a data source. The data source returns a row with delimited values (example: Dallas;Houston). The following error occurs on SET PARAMETER:
Error ==> Parameter 'Enter values for State:' only accepts a single value ...
In this scenario the data source returns a single row with multiple delimited values. InfoBurst assumes your intention is to pass the row result to the parameter as a single string of values. This does not work because the parameter type is EQUALS TO. If the data source returns multiple rows, InfoBurst will refresh once per row. To make this scenario work, the data source must return multiple rows each with a single value.
Bryan Baca
A BusinessObjects document contains an EQUAL TO parameter. The parameter value is supplied from a data source. The data source returns a row with delimited values (example: Dallas;Houston). The following error occurs on SET PARAMETER:
Error ==> Parameter 'Enter values for State:' only accepts a single value ...
In this scenario the data source returns a single row with multiple delimited values. InfoBurst assumes your intention is to pass the row result to the parameter as a single string of values. This does not work because the parameter type is EQUALS TO. If the data source returns multiple rows, InfoBurst will refresh once per row. To make this scenario work, the data source must return multiple rows each with a single value.