BAQ Report Designer and filters or option fields

Epicor ERP 9
1

Good Morning,

I am struggling with a BAQ report that is based on an external query. I have played around with the options fields per screenshot and then tried to use filters instead… and nothing i do seems to get me the right dataset for report (crystal). I have placed “company” data in there, and that had no effect.

I looked online for report of an SCR in this area, but see none. I’ve made these before, but I guess never from an external query. I keep wondering if that’s my problem.

Anyone else out there familiar with BAQ report designer option fields and filters not working properly?
I can suppress records on the Crystal side, but it seems ridiculous that I need to toss out a 1 mb xml file to reduce down the data to a fraction of the rows by making them invisible :frowning:

Thanks for thoughts.
Nancy

1.jpg1063×285 103 KB

2

I would change field labels typically to reflect the search condition.
Due Date GE
Due Date LE
SupplierID EQ
Plant EQ

Just in case when you run your report and accidently get your dates switched.
Add your Option Fields one by one and test to see where the issue is.
You can’t filter on an outer join table for example.
Hopes this helps.

Patrick Winter

3

Thanks very much for suggestions Patrick. I can’t get any of the darn options or filters to work, even one at a time :frowning: Eventually, I’m going to try some other external BAQ to see if that’s it, but for now, think I’ll go the brute force way and put the suppression into Crystal to get the job done for now.

Nancy