Dropdown list of values in Report Filter dialog

There are a number of fields (department and category are prime examples) which, when you add them as a filter on the Report Filter dialog, will show a dropdown list of values from which to choose. I would love to have that functionality on some fields which I have added to custom reports.

Fields such as Reason Code, Account Type, or Store Name (and other such fields where the plain-English value is stored in a separate table) are often used on my custom reports, and the users are constantly mistyping the value. If they could choose the value from a predefined list, it would make life so much easier.

I'm somewhat savvy with manipulating the code in the .QRP file, so feel free to post code snippets if that will show the solution.

Thanks!

Reply to
Bill Yater
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.