count of companies in various subreports

[HJM1234]

How do I get the count on the number of companies from different subreports? For example:
Company Name catagory other data
company A 1 data data data
company B 1 data data data
company C 1 data data data
company D 2 data data data
company E 2 data data data
company F 2 data data data
company G 2 data data data
company H 3 data data data
company I 3 data data data
ETC
How can I get the count of companys that have catagory 1 and 3
In my example it would be 5 companies. I have 5 catagories and each company can be in only one catagory. I am trying to write a report that has the catagories grouped. I can get the count for each catagory in the sub-report, but I do not know how to group them for the final summary.

Thank you.

 

[Pampers]

for grouping your output, you can use the sorting and grouping option. The first field to group on would be Categorie.

Toolbar > Sorting & Grouping



Pampers
Just let it go...

 

[HJM1234]

Hi

I have it group that way. I might not have been clear. In my subreports: Catagory 1 is 3
Catagory 2 is 4
Catagory 3 is 2
This I have already.
However, what I want is that at the end of the report is
(Cat 1 and 3) is 5
(Cat 2,4 and 5) is 37

I'm trying to run this report off of tables that I did not create. I can only read from the tables and can't create new fields. I was wondering if I make an alies, make catgory 1 and 3 the same, and 2,4 and 5 the same and then total them at the end of the report.
Thank you for your help.

 

[HJM1234]

Someone at work helped me. What he did was added a text box on the footer page.
=count([cat=1] or [cat=3],1,0)
another text box
=count([cat<>1] and [cat<>3],1,0)

This gave me the information that I needed.
Thanks for the help.

 

[Pampers]

Great!

Maybe this could work too.
=Nz(Sum(Abs(=1)))+Nz(Sum(Abs(=3)))

Pampers
Just let it go...