Report Totals by Category

[Cesar Ortiz-Lopes -]

Fellows:

I have a detailed report which has a field Id=Category
(with these values 1,2,3,4).

I DON'T using group level. ( Because of the report design)

I want to count records by each category field to be
displayed at the report totals legend.
[Ex. cat1=5, cat2=2, cat3=8, etc.]

I tried using RunningSum=Over Group, but always get the
total report count.

Maybe I can make an array counter, but a don't know how.

If anyone can help me will be appreciated.

 

[Jim/Chris]

Add an unbound controls in the report footer. Use the
following for the contol source

=Abs(Sum([FieldName]="cat1"))
=Abs(Sum([FieldName]="cat2"))

Jim

 

[Cesar Ortiz-Lopes]

Friends:

Perfect....

Thank-you for your help...

Cesar

-----Original Message-----
Add an unbound controls in the report footer. Use the
following for the contol source

=Abs(Sum([FieldName]="cat1"))
=Abs(Sum([FieldName]="cat2"))

Jim

-----Original Message-----
Fellows:

I have a detailed report which has a field Id=Category
(with these values 1,2,3,4).

I DON'T using group level. ( Because of the report design)

I want to count records by each category field to be
displayed at the report totals legend.
[Ex. cat1=5, cat2=2, cat3=8, etc.]

I tried using RunningSum=Over Group, but always get the
total report count.

Maybe I can make an array counter, but a don't know how.

If anyone can help me will be appreciated.



.

.