Does anyone know where I could find information for the syntax that Sage 100 Contractor report writer requires with respect to SQL.  I am trying to write a report for Committed Costs that is different from the report included with Sage, so I need to write more complex SQL statements with nested SELECT statements and the like.  The report writer documentation doesn't go over this in any detail.  I have searched the forums and all over the web and have come up empty.  Any help or direction is most sincerely appreciated.