Multiple values for Combo box in BIRT [message #362937] |
Mon, 02 June 2008 11:35 |
Eclipse User |
|
|
|
Originally posted by: mrong.facilities.rutgers.edu
Greeting,
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!
Mark
|
|
|
|
|
|
Re: Multiple values for Combo box in BIRT [message #363019 is a reply to message #363016] |
Thu, 05 June 2008 17:45 |
Eclipse User |
|
|
|
Originally posted by: brian.w.geary.saic.com
Mark.
your post below shows that you have a WHERE clause in your sql statement.
I am saying you need to remove that and replace it with a Filter within
your dataset.
Your dataset filter will look something like this.
expression => operator => Value 1
row["SOURCE_RELEASE"] In params["SR"]
Open your dataset, click on filters, and then click New and you should see
what I am talking about.
Mark Wrote:
-----------
Greeting,
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!
Mark
|
|
|
Re: Multiple values for Combo box in BIRT [message #363071 is a reply to message #363019] |
Mon, 09 June 2008 13:40 |
Eclipse User |
|
|
|
Originally posted by: mrong.facilities.rutgers.edu
As you suggested, the parameters are directly from user's input, right? Is
it possible to have combo box, so the user can select from the list or
type in more than one value for user's inputs.
Thanks.
|
|
|
Re: Multiple values for Combo box in BIRT [message #363107 is a reply to message #363071] |
Tue, 10 June 2008 11:59 |
Lars Johansson Messages: 18 Registered: July 2009 |
Junior Member |
|
|
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
input parameter.
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.
Lars
|
|
|
Powered by
FUDForum. Page generated in 0.02822 seconds