BAQ Report Filter Options - Help Needed

[dgreenEA (Dylan Green)]

Im having an issue with one of my baq reports. I want to be able to filter by Supervisor Name and have added it to the report. However, the drop-down for selecting filters does not show Supervisor Name. How do I go about adding Supervisor Name as a filter?

[ckrusen (Calvin Krusen)]

Here’s a whole topic on it…

BAQ Report Filter field

Hello, Does anyone got the answer for this question? According Epicor definition : Only columns from the BAQ that have an adapter are displayed in the list. This property lets this column link to other columns to restrict the data that appears I have POHeader.PONum and Project.ProjectID in my BAQ but it is not appearing in available filter list drop down.

Edit

Whoops … that doesn’t resolve the problem (unless rebuilding your BAQ from scratch does).

[dgreenEA (Dylan Green)]

@ckrusen,
This at least got me pointed in the right direction. I can always rebuild the baq if I cant figure it out. I added both supervisor id and supervisor name to the like section. However, only the supervisor id showed up and it includes entries for all employess under them instead of just giving me one entry for each.

[ckrusen (Calvin Krusen)]

I think I may have even just manually typed in the desired field name.

edit

Nope. that doesn’t work.

As others said, there needs to be an adapter (or something like that).

edit #2

You might be able to use an Option in place of the Filter. For the compare Operator, choose “List”.

While it wont give you the search functionality that Filter does, you can manually enter a comma separated list.