RDD table criteria

Epicor ERP 10
1

I am trying to add a table criteria to a RDD but when I use the Field Name drop down on the Data Sources > Report Table > Criteria tab, I’m seeing multiple instances of the field name. This is presumably because it’s showing fields from all tables within the RDD, but how do I now which one is from the table I want? For instance, there are four instances of Checkbox01 showing in the OrderAck RDD.

I want the one related to the CustCnt table and to set the criteria = TRUE. How do I know which one that is? Or is it just a matter of testing one by one until I get the desired result?

2

Just closing the loop on this for anyone searching later on. I “solved” my issue by picking the first instance of CheckBox01 and everything worked as desired. Whether that was total luck or not, I don’t know.

Quick edit: I also had to customize the grid view because the RValue field I needed in order to specify the True value for CheckBox01 was hidden by default.

1 Like