I have a database which is linked to our main student database via ODBC. We have used this database to report students with low test scores for 2 years.
I have been asked to include report card grades for students who are already on this report. Because the report card grades were from last (school) year, the tables which store the grades have been imported into the database so the grades are not coming in via ODBC...they are static.
Again, I am just expanding on an existing database.
There is a "main" (existing) query in the database for each grade level which "qualifies" students. Basicly it looks at specific tests for each student and if the student is "below" any one of the marks for any one of the tests the student will return on the query (I can include the SQL but it's long). This is what the main report is built off of.
There are 4 subreports on the report; one each for English, Math, Science and Social Studies. Each subreport is based on all students (query is based on another query which pulls the studnet ID and filters only Active students), and is linked to testing tables to pull all the "English qualifiers". Another query pulls all the "Math qualifers"...same thing for Science and Social Studies.
Everything I've stated above works great...now for the problem.
I created a new query to pull in grades. I thought the best way to do this is to create subreports just like I did for the test scores above. I use the same base query that I used in the subreports above and I just linked one other query and one table to it. The query runs great! The report runs great! But, when I put the subreport into the Main Report as I have for the other 4 it bombs! The system process and the message in the bottom left corner is Formatting page, press Ctrl+Break to stop... It will sit there for 5 minutes and never come up. When I get tired of waiting I escape out.
Is it possible that the report will not print the data because some of the data is coming in through an ODBC while other data is already in the db??? Any other ideas why it is soooooo slow???
Thanks for you help!
Hillary
I have been asked to include report card grades for students who are already on this report. Because the report card grades were from last (school) year, the tables which store the grades have been imported into the database so the grades are not coming in via ODBC...they are static.
Again, I am just expanding on an existing database.
There is a "main" (existing) query in the database for each grade level which "qualifies" students. Basicly it looks at specific tests for each student and if the student is "below" any one of the marks for any one of the tests the student will return on the query (I can include the SQL but it's long). This is what the main report is built off of.
There are 4 subreports on the report; one each for English, Math, Science and Social Studies. Each subreport is based on all students (query is based on another query which pulls the studnet ID and filters only Active students), and is linked to testing tables to pull all the "English qualifiers". Another query pulls all the "Math qualifers"...same thing for Science and Social Studies.
Everything I've stated above works great...now for the problem.
I created a new query to pull in grades. I thought the best way to do this is to create subreports just like I did for the test scores above. I use the same base query that I used in the subreports above and I just linked one other query and one table to it. The query runs great! The report runs great! But, when I put the subreport into the Main Report as I have for the other 4 it bombs! The system process and the message in the bottom left corner is Formatting page, press Ctrl+Break to stop... It will sit there for 5 minutes and never come up. When I get tired of waiting I escape out.
Is it possible that the report will not print the data because some of the data is coming in through an ODBC while other data is already in the db??? Any other ideas why it is soooooo slow???
Thanks for you help!
Hillary
