Report parameter combo box not populating [message #1801266] |
Wed, 16 January 2019 04:37 |
Tony Wolsey 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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03628 seconds