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!!
Since its crosstab, why don't you just add a OPTIONAL filter instead in your query something like this -
[cars] IN (?car_param?)
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
Problem resolved:
ParamDisplayValue('car_param') CONTAINS ('CAR-1') in Conditional Style does the trick. 8) 8)