BusinessObjects Board

Help using ALL in paramters

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’

Thanks a lot,
Tob


toblerone65 (BOB member since 2009-08-21)

hope you have checked This Post


cyberdude :india: (BOB member since 2007-02-05)

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


toblerone65 (BOB member since 2009-08-21)

I got it thanks all


toblerone65 (BOB member since 2009-08-21)