PROMPT SELECTION and BOX TYPE NONE

[gosoccer]

Ok, if someone can help me with this, it would be amazing. ::) ::)
I have two columns of the Crosstabs.

CAR 1            CAR 2
  1                    2
  0                    8

Now, I need to use the Conditional Style Advanced option to NOT To SHOW CAR1, if
CAR 2 is selected from the Body of the Report.
I'm using the following but it works only for selecting one Checkbox at a time from the Car Selection.

If I select CAR1 and CAR2 from the Checkboxes, None of the CARS listing is showing instead of
both CARS counts.

Here is the syntax I'm using within the Conditional Style:

ParamValue('car_param')  NOT IN ( '1','2')
and in the Advanced Style: Box Type: NONE

So, when the selection is 1 and 2, the listing should show. If the selection is 3,4, the CAR 1 and CAR 2 listing shouldn't show.

Please help if you could.

Thx so much for your time.
Happy Holidays!!

[cvamarley]

Since its crosstab, why don't you just add a OPTIONAL filter instead in your query something like this -

[cars] IN (?car_param?)

[gosoccer]

Good question,
For two reason:

1) Each Crosstab Intersection/column in this case is acting separately by itself since each Crosstab Intersection had to have it's own
Drill-Thru independently calling different Reports for Drill-Thrus.

If you know of a different way of approaching the estabishment of a Crosstab that could include different Drill-Thrus from each Cell, please let
me know.

Thx for your time

[gosoccer]

Problem resolved:
ParamDisplayValue('car_param') CONTAINS ('CAR-1')  in Conditional Style does the trick.  8) 8)