Parameter Lists Question

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Randy_Rinker_(Guest)
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Parameter Lists Question

Post by Randy_Rinker_(Guest) » Thu Jan 06, 2005 12:08 am

Is there a way to present the user with a list of options for a parameter, where the list is generated from the discrete values found in a field that is part of the table that the report is based on?__ IE, in a table of stock items, there is a field which lists the department. I want a user parameter for the department, so that the report lists all stock items in that department. There are more than 25 departments, so I can^t manually create a list, plus if any of the departments changed, it would require editing of the report. Instead, I would want to populate the list with a simple query like SELECT DISTINCT department FROM stocktable.__ Is this possible?____ Thanks,__ Randy__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Parameter Lists Question

Post by kfleming » Thu Jan 06, 2005 8:36 am

This capability will be added to the product shortly. In V11 a parameteRR can be created as a static list. Dynamically populating this list from a database table is in process and will be part of the first post V11 update.____Kathleen__R&R Support

Post Reply