Forum Discussion

JoeHargrave's avatar
Qrew Trainee
11 months ago

Limit Dropdown Choices from Reports

I feel like I'm missing something easy here....

In a form, when using a dropdown selector for records from any table, I can limit the choices to be based on filters in any report, among other easy methods.  However, in a report or grid edit report, when selecting a record in grid edit, I can't find a method to limit that selection to certain criteria, based on that specific report.  Can this be done?  

Joe Hargrave

1 Reply

  • Yes but this is not intuitive. You first need to make a new form on the child table - I would call it something like 'Grid Edit Form For xxxx Report'. On this form put all the fields you want the user to see when they grid edit. Typically, you just use the same fields that are already presented in the current grid edit, but you can choose any. Be sure your dropdown selector is there, and choose the filtered report.

    Then on the forms settings page, expand 'Override Settings by Report'. Find the report that the user is grid editing (the one where the filters do not exist), and under Grid Edit Settings select the new form you just made (Grid Edit Form For xxxx Report').

    Mike Tamoush