Improve company productivity with a Business Account.Sign Up

x
?
Solved

BIRT Multi-value list box

Posted on 2011-09-30
1
Medium Priority
?
2,001 Views
Last Modified: 2012-05-12
Greeting,
I use BIRT3.7 and want to create a report with multi-value list box for paramenters. It seems the parameter only take the first value from the list box. Is there anyway to take all the values. I am using the following sql in my dataset.
select * from tbl1 where field1 in (?)
Thanks in advance.
0
Comment
Question by:mrong
1 Comment
 
LVL 47

Accepted Solution

by:
for_yan earned 2000 total points
ID: 36895422

I don't know much about BIRT, but check this link (and you can download reprt design there).
It lloks like they are doing something similar.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/646-dynamic-multivalue-parameter-example-using-listbox/
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question