Here's a tip from the forums compliments of our friend andmy  fellow MVP, Victoria Yudin.

Victoria offers a SQL view to form the basis of the aforementioned SmartList using SmartList Builder.  You can take advantage of her work by clicking on this link - http://victoriayudin.com/2010/02/15/sql-view-with-ar-apply-detail/

Thanks Victoria.  You're the best!