Friends I have field and I want to use a promt on it it should give me all values presented in that field or else if user selects ALL it should return everything. I am using XIr2 I tried below way but I get error. ANy help?
Prompt(‘Select’,‘a’,,multi,free) in @Select() or @Prompt(‘Select’,‘a’,,mono,free) = ‘ALL’
I tried this W026DTA2.LIHEA_RECIPIENTS.FISCAL_YEAR in @prompt(‘TT’,‘A’, [‘Applicant Address & Contact Information\c1’],MONO,Constrained);
or
‘ALL’ in @prompt(‘TT’,‘A’, [‘Applicant Address & Contact Information\c1’],MONO,Constrained);
but get the data type for operands IN are not compatible