Jump to content
Sign in to follow this  
David Benedetti

Multikey / Subsummary Issue

Recommended Posts

Hey all, I seem to be having a bit of trouble with a report I'm generating from FileMaker.

I am trying to make a subsummary report, but it does not display properly. It is based on the Supervisors::Name field. It repeats some values, and omits others, seemingly at random, based on if there are multiple supervisors listed. It is a multi-key field

Attached are screenshots of the report and my database structure. Hopefully this is an easy fix, it's been driving me nuts for weeks...

db_structure.JPG

Report.JPG

Edited by Guest
Added clarification

Share this post


Link to post
Share on other sites

I think you may have some structural issues here. What layout is this report based off of and what is the purpose of this report?

Share this post


Link to post
Share on other sites

It is based on the Supervisors::Name field. ... It is a multi-key field

What exactly does that mean? If you are using a a field with a list of values as your breakfield, you will get a sub-summary for every individual combination of values. I have the impression that if you stretched the name field downwards, you would see what's happening.

Share this post


Link to post
Share on other sites

What exactly does that mean? If you are using a a field with a list of values as your breakfield, you will get a sub-summary for every individual combination of values. I have the impression that if you stretched the name field downwards, you would see what's happening.

Ahh, you are exactly right.

Is there any way top make it read each multi key as a single entry and sort it that way?

Share this post


Link to post
Share on other sites

Is there any way top make it read each multi key as a single entry and sort it that way?

No - and it wouldn't help anyway, because sorting is not the issue here. To take a very simple example, consider a table with 3 records:

#1. Category: A

#2. Category: B

#3. Category: A¶B

Ideally, your summary would look like this:

Category A:

• #1

• #3

Category B:

• #2

• #3

But clearly, this requires 4 records - and the same record cannot appear twice in a report. You need another table where the multi-line values will be broken up into individual records.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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