Stonefield Query has a powerful query builder engine under the hood. Based on which fields are used in the query, how the query is filtered, and how the results are sorted, it generates a SQL statement for the query. There may be times, however, when the requirements of a specific report means the generated SQL statement may not quite be right. For example, a particular report may need a full outer join rather than an inner join or a left or right outer join.

If you set the User Can Edit SQL Statement setting to True, and the user is defined as Advanced in the Maintain Users and Groups dialog in Stonefield Query, the second step of the Customize Report Wizard (invoked by clicking the Advanced button in the Data Selection step of the Quick Report Wizard) is the Customize SQL Statement step. In this step, the user can change the SQL statement used for the report. Obviously, only someone familiar with the SQL language should do this, but power users or developers may use this to create reports for other users.

See Also
Configuration Settings