Report Builder - basic query won't bring back part number

Epicor ERP 10
1

I have written a BAQ report with several subreports in Report Builder. The report runs perfectly for about 80% of our part numbers. However, on a handful of part numbers, the main report will generate without the subreports. Since the subreports take part# as a parameter, I tested passing the affected part numbers straight into the subreport and the report generated with labels but empty fields. In order to isolate my issue, I began testing with a very simple query in BAQ report designer, and I am able to run my desired query for one of the affected parts, and generate all my info fine, like so:

Screenshot 2017-05-23 08.06.36.png609×617 18.1 KB

HOWEVER: When I create the same exact query in Report Builder, I can’t pull back any fields for this part, including even the part number itself. I have been working in Report Builder without issue for awhile now, but this odd behavior has me stumped.
Screenshot 2017-05-23 08.06.53.png1013×494 36.8 KB

Screenshot 2017-05-23 08.07.06.png1125×603 34.9 KB

Screenshot 2017-05-23 08.07.22.png943×427 24.9 KB

Help!

2

In the BAQ you have the operator set to ‘=’ and in the report you have it set to LIKE.

1 Like
3

Thank you for your response. Unfortunately, I have tried it with “is” instead of “like” and get the same result. Also, part of my confusion is that the report and all subreports run for nearly 90% of part numbers. I feel like if there was something wrong with my queries, I would experience this problem across the board. Is there anything to do with ECO tables that could be affecting my results on a handful of parts?

4

Have you tried a left join join between part and partrev instead of inner join?
i.e. Are you sure there are matching PartRev records for all the Parts?

1 Like