Hi all,
I am workign in deski r2.
I have a report with 2 Data providers. From the first Dataprovider the values are passed to the second Data provider using “Select Query Results”. While refreshing the report I am getting the folln error “Too many selected values (LOV0001)”.
Could anyone sugest me the work around for this issue.
Thank You
daffodils (BOB member since 2007-08-09)
The filter condition is getting multiple values whereas it is expecting only one.
Please change the filer condition to allow multiple values (use in list).
Cheers.
BO_Stuffed (BOB member since 2008-03-29)
Select Query Results only shows up when “In List” is selected. When “Equal to” is the option then it’s Select Query Results (Any) which will handle multiple row inputs. So that’s not the problem.
The reason for the error is there is a minimum amount of data that can be passed on an IN clause to the database. The query in question has exceeded that limit and therefore cannot be run.
Dave Rathbun 
(BOB member since 2002-06-06)