So in the past, I have been able to dynamically add fields to a report selection grid as long as the field was on the "header" or "main" table for the report.
Now i'm trying to add a field from the detail table to the grid. I can add the field and everything looks great when I check the where clause built using coReport'ReturnSetupGrid(), I get the string seen in this picture.
So it looks like it should select the detail records correctly but when I process the report, my filter is not applied.
I'm setting the "Text$" of column -1 for the added row with the below line
LET GD_SELECT.CTL'TEXT$="TABLE=SO_SALESORDERHISTORYDETAIL;COLUMN=ITEMCODE$;ALELOOKUP=CI_Item;"
In conclusion, is it even possible for a report object to filter the "detail" records using the selection grid?
Is there something else I'm missing?