Conditional Fields

[Guest_imported]

I'm using CR 8
I'm doing a report based on one table...
The only fields I am concerend about are
Customer Name, and Region.

I had used 1 group. I group it so it displays all
custoemers that start with A, B, C, D, E.....Z

Now, in every group footer i want to have a short summary.
I want to summerize the total counts of all the regions
that were displayed. But not the ones that were not
displayed... like this:

Customer Region
Aaaaaa KO
Abbbb CC
Acccc FF
Addddd KO
Aeeeee FF
Afffff CC

KO Total Count: 2
FF Total Count: 2
CC TOtal COunt: 2


How can i acomplish this in the most efficient way?
Keep in mind that there is about 1000 regions.
SO i don't wanto have 1000 conditional fields,
I already know how to do that,
but it doesn't make sense...

any help would be apriciated.

 

[kenhamady]

Have you tried a cross-tab based on that field? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

ConfusedZiggy: Try inserting another group (by Region) as level 2. This will enable you to then do a count at level 2 (i.e. by Region) within each initial letter and only the regions actually encountered will be included - If you need a count of all letters within a region change the groups to have Region as level 1 David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[Guest_imported]

OKay.
Grouping it twice was a good idae, cause I could get the
count. I can't get it in alfabetical order in each letter anymore, but that doesn't matter.

Now how do i get it to produce the
final total:

KO Total Count: 2
FF Total Count: 2
CC TOtal COunt: 2

?
thanx

 

[dcm]

ConfusedZiggy: To re-arrange the order of items within a group investigate the use of the specified order option. This enables you to decide EXACTLY what order the individual items within a group appear in.

The final total should be easy to achieve by using a Distinct Count but if you explain more precisely what you are trying to achieve I can be more precise in my suggestions David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

It sounds like you need several totals of groups that have appeared within the report.
I am not sure, but it sounds like a cross-tab would give you the summary you are looking for at the end. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal