|Multiple values for Combo box in BIRT [message #362937]
||Mon, 02 June 2008 11:35
Originally posted by: mrong.facilities.rutgers.edu|
I have a combo box setup for oen report parameter. I want to let the user
to type in multiple values in the combo box then run the report. But it
keeps getting no records on the report. If the user only input one value,
the report works. I did change my sql to" select...from....where value in
Thanks in advance!
|Re: Multiple values for Combo box in BIRT [message #363107 is a reply to message #363071]
||Tue, 10 June 2008 11:59
| Lars Johansson
Registered: July 2009
I also want to have multiple values in parameter selection. Since the |
bugzilla entry, https://bugs.eclipse.org/bugs/show_bug.cgi?id=208477, is
moved to a future release, I have explored other solutions.
However I don't want to use filtering as described because this, at least
as I understand, is done after the sql query have been executed. I want to
do the filtering before the sql query have been run in order to get less
cpu load, less network traffic, etc.
My solution is to use combo box together with stored procedure. Either I
select a value in the combo box, which is then an input value to the
stored procedure. The selected value, i.e. the parameter value, is
transferred to the stored procedure, which takes comma-separated string as
Or I use the text box accompanying the combo box. In this textbox I write
comma-separated value. This is, like above, input to the stored procedure.
Of course the stored procedure must be able to handle this, but after that
is solved this way works.
Powered by FUDForum
. Page generated in 0.07558 seconds