Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Multiple values for Combo box in BIRT
Multiple values for Combo box in BIRT [message #362937] Mon, 02 June 2008 11:35 Go to next message
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 #362960 is a reply to message #362937] Tue, 03 June 2008 14:05 Go to previous messageGo to next message
Eclipse User
Originally posted by: brian.w.geary.saic.com

I do not believe BIRT supports ? with multiple values.

To do this.. within your data set make a filter like

row["SOURCE_RELEASE"] In params["SR"]
expression => operator => Value 1


bg
Re: Multiple values for Combo box in BIRT [message #362961 is a reply to message #362960] Tue, 03 June 2008 14:06 Go to previous messageGo to next message
Eclipse User
Originally posted by: brian.w.geary.saic.com

You also need to remove "...value in (?)" from your query.
Re: Multiple values for Combo box in BIRT [message #363016 is a reply to message #362961] Thu, 05 June 2008 17:22 Go to previous messageGo to next message
Eclipse User
Originally posted by: mrong.facilities.rutgers.edu

badguy wrote:

> You also need to remove "...value in (?)" from your query.


Not quite follow you here...
Re: Multiple values for Combo box in BIRT [message #363019 is a reply to message #363016] Thu, 05 June 2008 17:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Lars Johansson is currently offline 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
Previous Topic:How to include multiple javascript files in a report ?
Next Topic:dynamic table column
Goto Forum:
  


Current Time: Sat Sep 20 06:17:52 GMT 2014

Powered by FUDForum. Page generated in 0.01792 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software