SQL Wizard - Create Query

The last step in the SQL Wizard will create(write) your SQL Query for you. Press Finish to see the SQL Statement after confirming the limitations and print options. If you manually make any modifications to the SQL Syntax created by the SQL Wizard, it will be overwritten when you use the SQL Query Wizard again.

Results Limitations

Select only DISTINCT records - If all columns in the row are the same as another row, the record will be ignored. This is only valid when ALL columns are identical.

Hide all Detail Records (HIDEDETAIL) - Select this option to only show Sub Totals lines on a report. The line items that make up the subtotal will be hidden. For example, if you only want to see the balances of your city ledger accounts, but not each invoice that makes up the balance. This feature only works when columns are being subtotaled.

Hide Grand Total (HIDEGRANDTOTAL) - Select this option to hide the Grand Total on a report. This feature only works when columns are being subtotaled.

Limit query to number of rows - Only a maximum number of records indicated here will appear in the results set.

Report Options

Group Data by column one when printing report – Select this option to sort the report by the field selected for column one. For instance, to sort a report by room type, make BEDTYPE from the ROOMS table the first column and select this option. The sorting will show once a report is written. It will not appear in the Data Grid Preview.

Skip Data Grid Preview and immediately print report - Checking this will skip reviewing the Data Grid prior to previewing the report.

Report Spacing - Select single, 1.5 or double space from the drop down menu.

Report Footer - Optional text to print in bottom right hand corner of report.

Export Extension (Optional)

Export Extension - If you have previously created an Export Extension from the Export option in the query, you can enter the file specification name here. This will make the export execute automatically when the query runs without showing the result set to the user.

Auto Save Query Wizard Specification when pressing Finish – Selecting this option will automatically save any changes that were made to the specification. It is not recommended to select this option if you are testing different variations of a specification since it will overwrite the previous statement.