I have created a web database to use on SharePoint. The database has 7 queries - one finds all records and the other six queries find records by status and by region (example: I want all active records for the Southeast region). The All Records report displays fine, but the other reports give me a "Form compilation failed" error message. Other than the difference in queries, the reports are identical.
Any ideas on how I can fix this?