Creating Reports for a Class

[Ben Feingold]

I have databases:

Behavior - Collects behavior problems

Attendance - Collects attendance info

Class Lists - creates reports with the above data

I would like to create a report that shows the data for a classroom over a defined date range. After sorting by class I would like it to show the data for each student. I can't seem to get it to list more then one student per class.

Thoughts?

[-Queue-]

Do you not have a Student db? It would probably be easier if you did.

You need to run your report in the file that contains the data for each student. You can use related class info for the subsummary.

[Ben Feingold]

I do have a Student DB. It contains fields like Student Name, Homeroom, Grade and then a tally of all behavior problems and attendance issues. I would like to create a report that displays the behavior data by Homeroom>Student>Date>Time

Currently, when I create a report, I do it from the Behavior DB and draw names and classes from the Student DB. Then the behavior information is combined with it. The final report shows every behavior entry ever entered.

What I would like it to do is only show the data for the last 14 days. I put in a calculation field that reads, "Status(CurrentDate)-Date:<= 14" This returns a "1" if the record is less then 14 days old.

How do I get the report to EXCLUDE record that don't have a "1" in this field?

[transpower]

So, in Find Mode, enter 1 in the calculation field, which will then find all records less than or equal to 14 days old.

[Ender]

This is not an efficient way to do this search. Using Status(CurrentDate) in your calc makes the calc unstored. Searching on unstored fields can be very slow over a slow network, or when there are many thousands of records.

A better way is to search for Dates within the last 14 days is like this:

Go to Layout [ SomeLayoutWithDateField ]

Enter Find Mode []

Insert Calculated Result [ Date , ">=" & Status(CurrentDate) - 14 ]

Perform Find []

Since the Date field itself can be indexed, this search will be very fast.