Suppose there is a list of students in Servoy, existing as a foundset.
If I have a Jasper Report, I can print the list of student names by passing the student foundset, e.g., for three listed students,
- John Smith
- Rudy Jones
- Debby Lowell
Some of these students currently are enrolled in classes (services). Suppose I would like one row for each student-service combination valid within a date range. If two of the three students have services within the date range, I’m guessing that I could search for all valid services, then pass to Jasper a services foundset, e.g.,
- John Smith taking Dutch
- John Smith taking English
- John Smith taking PE
- Rudy Jones taking Math
But what if one of the students (Debby Lowell) hasn’t any valid services within the date range, but I still want her listed, e.g.,
- John Smith taking Dutch
- John Smith taking English
- John Smith taking PE
- Rudy Jones taking Math
- Debby Lowell (no services in period)
How do I let the Jasper report know to include Debby, and any other students in the original list that don’t have services within the date range?
Thank you,
Don