I have a list box for the CMR_Desc field which works as intended. The CMR_Desc field comes from a table which is a data island.
When a value is selected the report adjusts accordingly.
The problem started after I added a Select in Field trigger so that this list box maintains a default value even when the everything is cleared. I used the expression below to create the trigger. I have used the same expression is other reports and it works as expected.
The aim here is to only have 1 value selected with the Default value being 'All' (not all values. Just 1 value 'All'). As I said in the post my current methodology is working in another report. I don't know of any way to to debug this issue.