Page 1 of 1

Parameter Lists Question

Posted: Thu Jan 06, 2005 12:08 am
by Randy_Rinker_(Guest)
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__

=> RE: Parameter Lists Question

Posted: Thu Jan 06, 2005 8:36 am
by kfleming
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