Within my database I have a report (BusStopsByRoute), and, somehow it is displaying only portions of a query that retrieves rows. Initially one would think that there is a problem with the relationships however, a separate query returns data correctly, hence, the problem is thought to be an issue with the report itself.
Attachment includes screenshot and SQL query.
Database is available at https://skydrive.live.com/embed?cid=...O8Y13CuRuXLx2k.