Skip to content
Home » Latest Blog & Articles » Select from List to Filter

Select from List to Filter

    With .Net Report Builder, your end users can easily select values from a drop down list to filter their Reports, instead of typing in values manually.

    To allow selecting from a list, you must setup a Foreign Key when setting up the schema in the database.

    For example, if your “Orders” table has an “EmployeeID” field, you would set it up this way in the admin section:

    Check the “Foreign Key” option, and then fill out details for the Foreign Table and Join. See example in screenshot below:

    With the Foreign Key setup , when a user chooses Employee in the Report, they will see the following options in filter:

    When the user chooses “=”, they can select one value from the drop down:

    When they choose “in”, they can select more than one values in the drop down:

    The Report will apply the filter for all selected values from the list.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Self Service Embedded Analytics

    Need Reporting & Analytics?

    Join us for a live product demo!We’ll  walk you through our solution and answer any questions you have.