Jump to content

Display by total children


mleiser
 Share

This topic is 5799 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a file with student records. Each student has its own information and a parent id. I need to determine how many children are in each family and pritn a report that is sorted by that number. For example Davey Jones might have 5 children in school. Tom Lasorta, 4. Anna Frank, 5. It should come out with a 5 children group displaying Frank and 5 children, and Jones with the 5 children info. Then the 4 children section with Lasorta and children info. As I mentioned, I can differentiate parents using the parent id.

Thanks,

Mike

Link to comment
Share on other sites

You can use a columnar report with sub-summary parts, having a Sub-Summary by ParentID part where you can put the Parent Name(s) along with a Count of RecordID summary field.

In order to get the parts to summarize and sort the way you want, you should Sort by ParentID, and reorder by the Count of Records summary field.

Link to comment
Share on other sites

Hmm, in FM6, I think this is a little different.

I think in this case you would need to define an aggegate calc in the Parent file:

NumberOfChildren (calculation, number result) = count(Child::ChildID)

Then sort and sub-summarize by this for the sub-summary report.

Link to comment
Share on other sites

This topic is 5799 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.