Modifying Report Selection Grid Question
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 the attached picture. So it looks like in 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;""
Is it even possible for a report object to filter the ""detail"" records using the selection grid?
Is there something else I'm missing?