How to do report with 15 break fields?

[Andrew5]

How to do a report with 15 break fields? There are about 100 clients, their contact layout is the parent table. Each client has three fields reporting a status, and each of those three fields is a drop down list of about 15 status-types. I need a report on those 15 status types as the break fields, listing the names under each status-type. Each client therefore will appear up to three times. HOW?!

I am stumped right now. In my attempts I have now entered the statuses in two different ways on the main layout, 1) as three text fields in the main layout and 2) as a portal. Thanks.

[Ocean West]

Not sure what your "report" looks like would this help?

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

[Andrew5]

I need this:

----Status1

Adams, Bill

Brown, Mike

Smith, Ron

----Status2

Jones, Abe

Smith, Ron

----Status3

Brown, Mike

White, William

etc.

[comment]

If I understand this correctly, you have 15 groups (status), and a client can belong to up to three of them?

There is no way a report will list the same record more than once. If you have records that belong to multiple groups, and you want a report that lists the members of each group, you will have to change your data model, and use a join table to associate clients with groups. See:

http://www.fmforums.com/forum/showpost.php?post/246136/

A possible workaround is to have a table of groups and produce the report from there, using a sliding portal to list the clients of each group.

[Andrew5]

Hmm. You understand perfectly well. I'll give the slider thing a try..... thanks.

[Vaughan]

I agree with Comment. However a workaround would be to run the report separately for each group, and join up the reports.

[Ocean West]

And an easy way to do this is with this technique...

I just implemented it in a project.

http://www.filemakermagazine.com/videos/combining-pdfs-the-blazing-fast-method.html