882 summaries

[keydash]

I have a summary problem:

Each record belongs to one of 14 main areas. Each of these areas has 9 more subdivisions, and each of these is further subdivided into 7.

Let's name one of the 14 as AI, the next divisions are named 1 through 9 and the last subdivisions are named A through G. I need to produce a summary of each of the respective combinations. Such as

AI 1 A......AI 2 A......AI 3 A......AI 4 A......AI 5 A

AI 1 B.....AI 2 B......AI 3 B......AI 4 A......AI 5 A......and so on.

I can accomplish this by using a Find based on the 3 divisions, Status (CurrentFoundCount), and setField. However there are about 882 combinations. Surely there is a better way than doing 882 find scripts.

As usual any and all help is appreciated.

Al

[danjacoby]

Create a subsummary part based on the combination field, then sort on it and print the report. It'll divide everything up for you.

[keydash]

Yes, this does show the divisions and the records within each. I failed to mentioned that it is the actual record count of each division that I need. And these record count numbers need to be placed within their appropriate

[Ugo DI LUCA]

What about using some relationship here and use the Count (relationship) function for any Division, Group, Department,...

This is quick and reliable...

[Arty]

Hey I have a problem like yours and I also need help. If you can remember what you did anytime, please let me know.

Arty.

[Ugo DI LUCA]

May be it would need some adaptation, but here's how you can do this.

Let's call the Groups "Main Group", "Division" and "Department".

You'd agree that :

- a Department is linked to a Division and a Group

- a Division is linked to a Group.

What you need is a file with these fields :

1. Category ------> return the category of the current record ----> Main Group, Division or Department

2. Serial#

3. a Record_ID autoentered by calc "ID"&Right("00"&Serial#,5)

4. Group_ID and Group_Name

5. Division_ID and Division_Name

6. Department_ID and Department_Name

Each field would be populated by the referenced Ids, the Record_ID being attributed to the current "Group" according to the category selected.

7. A set of 3 calculations that will return the current Group_ID, Division or Department_ID, this way :

c_return_Group ID = Case(category = "Main Group", Main Group_ID, " ")

c_return_Division ID = Case(category = "Division", Division_ID, " ")

c_return_Dept ID = Case(category = "Department", Department_ID, " ")

8. A Multikey Calculation = Group ID&"PP"&Division ID&"PP"&Department ID

Therefore a Department would have a Multikey composed of 3 Ids (Group, Division and Department), a Division would have a Multikey composed of 2 ids (Division and Group) while a Group would have only its own Key.

Some more settings could be suitable, but you can start with this.

Therefore, you understand that you can relate c_returnGroup_ID with the Multikey and you'll therefore have a list of all divisions and departments related to that ID...

To have a better view of what this could be, just download the sample "records in folders" in the Sample Section as it is a slightly near adpatation from this technique.

[Ugo DI LUCA]

See attached a sampler with 7 groups, 9 sub groups and 7 departments.

882subdivided.fp5.zip