Selection Formula

[Dov2]

Hi,
I have this structure:

Company 1
Company 2 - Departament 1
Departament 2 - Employee 1
Employee 2
....

How can I create a formula to count all departments.

Thank you

Dov2

 

[nomates]

If you have grouped your report as shown then you could add a running total to count on change of department. This would work only if the Departments where different in each company.

 

[kenhamady]

You could do a distinct count of the department name or the departmetn ID. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Dov2]

The distinct count is good if I have a single field key , but how can I do it if I have multiple fields primary key in Departments Table?

Thank you.
Dov2

 

[kenhamady]

Combine them into one field (concatenate if they are strings), and do a distinct count of the formula. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com