Using FileMaker Pro

Are "open" and "Received" the only possible values in the status field? I'll assume that this is not the case. (You can simplify this approach if these are the only possible values.)

Define a pair of calculation fields as:

cOpenFlag: Status = "Open"
cReceivedFlag: Status = "Received" //modfiy the text in quotes to match the actual values entered in this field.

Then summary fields that compute the "total of" these two fields will give you the total number of records with each status. If you based your layout on Lesson-Task, you could set up calculation fields such as these for computing percentages at the Domain level:

GetSummary ( sTotalOpen ; DomainField ) / Get ( FoundCount )

GetSummary ( sTotalReceived ; DomainFIeld ) / Get ( FOundCount )

The calculations for the other levels are the same except you specify a different "break" field in place of "domainfield". The fields you specify there are the fields that are selected as the "when sorted by" fields for each sub summary part.

WIth the layout based on Lesson-Task, the last sub summary part would become the body layout part instead of a sub summary part.

The only drawback to this report is that it will leave out all lessons that do not have any task records in your report's found set.

A dummy record in tasks is an option to consider.

The alternative may be a one row filtered portal with summary fields that use the "fraction of total" option on the cOpenFlag and
cReceivedFlag fields com compute your percentages. The filter expression would need to replicate the logic that determined what lesson records are in your found set and which also filters by "domain" to get the correct set of related task records. Depending on what criteria you may need to specifiy for the found set of lesson records this could be easy or complex to implement.

What is the typical criteria you specify when pulling up your found set of records for this report? (Date range? Subject? or ???)

Are you using FileMaker 11 or 12? (Must have at least version 11 to use filtered portals.)

at this point

But can you forecast how you might need to use this report? Such as all lessons for a specific text book or ???

It's not a trivial thing to deal with if we go with filtered portals.

You may have this set of relationships or you may need to add one more occurrence of Lessons to use for this:

Lessons----<AllTasks>----Lessons 2

Lessons::AnyFIeld X AllTasks::AnyField
Lessons 2::LessonID = AllTasks::LessonID

Using the X operator matches any record in Lessons to all records in Tasks. This produces a relationship where a portal to AllTasks will list all the tasks records in your tasks table until we employ a portal filter to reduce the number of records.

The sole purpose of Lessons 2 is so our portal filter can filter Tasks records by a value in one of your "level" fields such as "Domain".

You can then define sFractOpen and sFractReceived as "fraction of total" summary fields that refer to cOpenFlag and
cReceivedFlag respectively.

You can then put a one row portal to AllTasks in your Domain sub summary part and put sFractOpen and sFractReceived in the portal's row. The final requirement is a portal filter expression such as:

Lessons::Domain = Lessons 2::Domain //This is where you'll have to add additional details once you need a report that does not include all records in teh Lessons table.

You know, Phil. I think I'll go with option a. I think a task per lesson with the status unassigned will work just fine. All lessons need the content created as the first task, so I think it's ok to have the records.

All table occurrences have a found set whether you have performed a find on a layout that refers to them or not. You need the total count of the records being summarized. Keep it as it is.