I am trying to create a report that displays the field "First Name" when a child meets a certain criteria in another field.

I want to list all the names of the children who meet specific criteria.

Eg if a child is chosen as Blue from a value list (Blue, Green, Yellow, Red) I want a report to list all the children who are Blue, all the children who are Green, all the children who are Yellow and all the children who are Red.

Is it possible

Many thanx

Poida

You can do this with a sub-summary report. Create a layout with a sub-summary part sorted by the name of the field containing blue/green etc. Then in the body part, place whatever fields you need to use for the children.

Now, sort the records by the blue/green field, then the order for the body part, and preview the records.