logic for selecting all values in a table

[srivalli]

Hi all,

I need logic correction. Requirement is..

Column has c1 and c2 values.we are using static choices prompt with options c1, c2, c1+ c2.if user selects c1, c1 values should be displayed. if he selects c2 values should be displayed. if he selects c1+c2, both c1 and c2 values should be displayed.

use value for c1+c2 is 9999

Filter condition is
IF (?parameter? = 9999  ) THEN
    ([Product line code] = 'all' )
ELSE
    ( [Product line code] = ?parameter? )

it is not taking all option. could you please correct the logic. if it cannot be achieved through static choices, how to do with value prompt..help me please.

Thank you

[blom0344]

Are you not making this too complicated? Simply define a multi select value prompt through an additional prompt query. The user can then select c1 or c2 or both.  Then feed the associated prompt parameter to the data query..