Subscriber/Dependent Combo Box in BAQ Report Interface

Epicor ERP 10
1

I have a BAQ report that is filtered on Part Number and Lot Number. These are options (not filters) in the BAQ Report Designer, resulting in Textboxes. To ease user input, I replaced these with Combo Boxes. The first is a BAQ Combo showing a limited list of Part Numbers matching the desired list to be selected for this particular report. I would like the second Combo Box to only show lots for the part selected in the first box.

I watched this video (thanks Jose) and implemented what I could:

First box: BAQCombo bound to ReportParam.Field1
Second Box: EpiCombo bound to ReportParam.Field2
EpiBOName: ERP:BO:LotSelectUpdate
EpiHiddenColumnsAppend: PartNum
EpiFiltersAppend: PartNum = ?[Field1, “”]

Error when clicking the dropdown on the Lot Combo Box:
“Error accessing the database: Conversion failed when converting the nvarchar value ‘X’ to data type int.”
where X is some random unrelated lot tracked part.

I can’t figure out where I have introduced an integer since everything should be strings.

Thanks in advance for any help!

2

I found Jason Wood’s reply to another question about combo boxes that helped me here. I was able to solve this with his screenshot found in this post.

Box 2 properties:
EpiFilters: PartNum = ‘?{Field1Column,’‘}’
EpiFiltersParams: Field1Column=?[Field1]

3 Likes
3

You can mark your own posts as the solution.

4

Hi Craig I’m having the same issue and have created a BAQ report so production can reprint material tags. But have not had any success getting my second combo working. Any guidance would be greatly appreciated.

5

Michael,
Can you share what you have tried so far? I found the screenshot in Jason’s post linked above to be useful for getting the right filter properties.