how to do category prompt to Status date item

[PrawinM]

I am having category prompt on Status data item . users want to select 'abc' Status   for one category and which is not equal to 'abc' another category  and last one is display both ,

Please help me

[MFGF]

I am having category prompt on Status data item . users want to select 'abc' Status   for one category and which is not equal to 'abc' another category  and last one is display both ,

Please help me

Hi,

Sounds like your filter expression needs to be in the form

([Category] = 'One category' and [Status] = ?Your prompt parameter?) OR ([Category] = 'Another category' and [Status] <> ?Your prompt parameter?)

MF.

[PrawinM]

i didn't get you Am explaining in Detail with attached excel please help me


Thanks in Advance ,
P.K

[MFGF]

i didn't get you Am explaining in Detail with attached excel please help me


Thanks in Advance ,
P.K

Hi,

It's not clear what you want to achieve - at least to me. Where are the value prompt values coming from? Are they manually entered? Are you looking to filter your result set based on the selected prompt value?

MF.

[PrawinM]

Sorry for that its my bad.let me explain clearly

in a value prompt i want static choices as a,b,c of acolumn name is 'xyz'

'xyz' has data of 01,02,03,04,05,06

Condition's

a = 06
b <> 06
c display both


its like a gender prompt


Thanks in advance.
P.K

[MFGF]

Sorry for that its my bad.let me explain clearly

in a value prompt i want static choices as a,b,c of acolumn name is 'xyz'

'xyz' has data of 01,02,03,04,05,06

Condition's

a = 06
b <> 06
c display both


its like a gender prompt


Thanks in advance.
P.K

Hi,

In that case, you would need a filter expression that uses this approach:

([xyz] = '06' and 'a' = ?Your prompt parameter?) OR ([xyz] <> '06' and 'b' = ?Your prompt parameter?) OR ('c'  = ?Your prompt parameter?)

Cheers!

MF.