Adam Hague
If you try search for an Account name which has a special char in (such as an apostrophe) it will convert it to a HTML entity and the query won't bring back results.
Example: Search for
Rosa's Thai
http://data1.internal.airship/report/html/?report=client_activity_and_data_reports/Internal%20Reports/Units%20and%20Unit%20IDs%20on%20Account.sql