Group Selection formula and a Crosstab

[crcdata]

Hello:
I have built a report that is looking at the type of shipments on trucks. There can be any combination of five different shipment types on a trailer.

Now I am trying to build a report that will find trailers that have only one type of shipment. I have finished working on the group selection formula for the report so the report is showing records of trailers that have only one type of shipment. But the crosstab in the report header in the report is still summarizing records of all types of shipments.

Is there a way to force the crosstab to look at the records that have been filtered by the group selection formula. If so how do I do that. The only thing I can think of is a rather time consuming process of building a subreport that has a manual crosstab.

 

[Madawc]

Do Max and Min for Type within a group. Suppress when these are not the same.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

If you are using CR XI, you can create a formula like:

if distinctcount({table.shiptype},{table.truck}) = 1 then {table.truck}

Use this as your row field in the crosstab.

-LB