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