To get around this problem http://suitecrm.com/forum/bug-tracker/542-reports-not-working-with-custom-fields, I have created a sql query and exported it to Excel for my staff.
It would work much better to be able to create a report based on a SQL query instead of creating the query within the application. That way I have only one place for people to go for reports. Currently they have two places. One for reports that work in suite and one for reports that are too complicated.