There are several available preferences that you can use to modify the overall look of your report. These preferences will apply to every query run, but can easily be changed at any time.

Field Labels:

Alternate Row Color: For longer reports, it's often difficult to keep track of which line of data you're looking at. You can have ClickQuery automatically color every other line on your report by checking this checkbox. You can choose from Light Yellow, Light Gray and Light Blue. NOTE: If the checkbox is UNCHECKED, no alternating color will appear on your report, regardless of the color chosen in the pop-up menu.

Remove Underscores: Since field names in SQL often contain an underscore ("_"), checking this option will automatically remove any underscore in the name of the field when it appears on your report.

Show Report Formatting Options For Each Query: By checking this option, you will see the report formatting options each time you run a query. Unchecking it will use the currently set formatting options each time.

Fonts and Alignment:

Font Face & Size: These settings will determine the font and size for the ENTIRE report.

Alignment Fields: When you create a query ClickQuery will extract the datatype of the column(s) you select and you can specify how number, dates and money fields are aligned.
NOTE: These alignment settings (as well as the currency symbol) will have no effect on custom queries, because ClickQuery does not "track" the columns used in the SQL statement.

Report Preferences:

Include Report Details: Checking this option will include a small table at the end of your report containing the name of the query run, the number of records contained in the report and the elapsed execution time. Unchecking this option will not generate the details of the report - regardless of the other checkboxes in this section. The report details table will look similar to this:

Report Created:	4/21/2001 at 6:13:28 by ClickWare
Stats:	Records: 91, Elapsed Time: 00:00:03
Query Name:	Documentation Example

Include Report Date/Time: Includes a row that displays the date and time the report was run.

Include Report Creator: Includes a row that displays the FileMaker user name (accessible in the FileMaker Pro Application Preferences in the FileMaker "Edit" menu) of the computer that created the report.

Include Report SQL: Includes a row that displays the the SQL query used to generate the report.

Database Preferences:

Database Platform: This version of ClickQuery only supports Microsoft SQL Server.

Include Views As Well As Tables: Checking this option will cause ClickQuery to include all database views as well as tables in the "Tables" listing - allowing you to perform SQL operations on both types of data.