combo box parameter

rzaxl4861

dear all <br />
<br />
im trying to create a report with a combo parameter, the first sql statement is just a simple <br />
<strong class='bbc'>SELECT * from idea where idea_sponsor like '%?'</strong><br />
<br />
what is displayed on the report will be<br />
<br />
idea_id, idea_title, idea_benefit, idea_date, idea_sponsor<br />
<br />
The parameter should be a combo box parameter that lets the user choose idea_sponsor field to filter the report, but for some reason when I create a parameter it wont display idea_sponsor could any one help me please

ahsiang

Hi, here's a sample of a very simple listing report with combo box parameter. Usually we will create a data set for the filter to improve on the performance. This is using Eclipse BIRT 2.6 designer.