Has anyone created a custom Progress Report for FAWEB showing the Category Averages using the EA Open Database module. We are a standard based school and need to print progress reports for our students showing how they are doing in each category (we use a category to represent a standard). Ideally, the report will show us: The students name Each course that the student is enrolled in with the Teacher’s name The categories (or standards per each course) The over all course average for the course Each teacher can print this report through FAWEB. However, we would have to manually collate them for each student. So we would like to run a Crystal report to give us the desired collated copy for students. The FAWEB teacher’s student reports present the data in a 100% scale for category averages. We also need to convert the 100% scale to a 1 to 4 point scale, which is what our standards are based on. This should be doable via a formula in a query to extract the aforementioned data. We have a short time frame, 2 days as of today, 10/14/03, to get our progress report out. Any help would be appreciated. We are desperate and I can be reached at 707-333-5778 if you can assist. Ricardo Llewelyn Director Technology Mare Island Technology Academy Vallejo, California