Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Report parameter combo box not populating
Report parameter combo box not populating [message #1801266] Wed, 16 January 2019 04:37 Go to next message
Tony Wolsey is currently offline Tony WolseyFriend
Messages: 3
Registered: January 2019
Junior Member
Hello
Please forgive the simple question but I am a very new user.

I am trying to create a simple report parameter and have a combo box appear at runtime for the person to select. I am connecting to a MySQL DB.

1. I have created a report parameter (rp_companyname), selected combo box, selected dynamic list, selected the dataset (Test25), selected the value column (company_name).

2. Then I inserted a parameter marker in the SQL query for Test25 dataset
select customers.company_name,
customers.contact_name,
customers.country
from customers
where customers.company_name = ?

I then edited the parameter in dataset Test25 to link to rp_companyname.

When I run the report to PDF (for example), I see the parameter dialog box, but the combo box is empty.

Note that I have also tried to use a static list of values for the combo box but when I try to import the values in the Report Parameter dialog box, the values are empty also.

What am I doing wrong and/or what else must I do to make this work?

thanks
Tony







Re: Report parameter combo box not populating [message #1801330 is a reply to message #1801266] Thu, 17 January 2019 01:43 Go to previous messageGo to next message
Colin Sutton is currently offline Colin SuttonFriend
Messages: 121
Registered: July 2009
Senior Member
Your test25 dataset should be:
select customers.company_name
from customers

without the where clause

[Updated on: Thu, 17 January 2019 01:44]

Report message to a moderator

Re: Report parameter combo box not populating [message #1801331 is a reply to message #1801330] Thu, 17 January 2019 03:10 Go to previous message
Tony Wolsey is currently offline Tony WolseyFriend
Messages: 3
Registered: January 2019
Junior Member
you are brilliant Colin!

I was following the instruction in the help menu for BIRT where it instructed me to "insert a parameter marker in the SQL query". I am clear now that I should not of added the where clause.

thanks
Tony
Previous Topic:Report parameter combo box not populating #2
Next Topic:Dynamic combo box doesn't pass value field
Goto Forum:
  


Current Time: Tue Mar 19 10:21:13 GMT 2024

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

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

Back to the top