Features

The SQL wizard eliminates the need for you to know the sometimes arcane and complex syntax for coding SQL statements. It provides a sophisticated interface that helps you build the correct SQL statement for your reporting requirements with prompting, drag and-drop and real-time syntax checking.

At anytime during the SQL wizard process you can click the View Data button to preview whether you're getting the data you need or whether you need to go back to an earlier step and adjust your settings.

Join any number of files by dragging and dropping the linking fields and selecting the join type (Inner, Right Outer, etc) from a drop down box.

Easily select a subset of records from your database files by using the Filter Records wizard. Choose the fields and operands you want to filter by which automatically generates an SQL where clause for you. You can even include runtime variables during the development phase, so you can dynamically test your filters to ensure you get the correct subsets of data.

Sort data by any of the fields or derived values in your report prior to displaying the report by simply selecting the fields to order by from the Order/Level Break wizard screen. To create level breaks simple check the box of the fields you want to break on. Headings and total lines will automatically be added for each level break.

To create a subtotal over a field you just need to check the box next to the field from the Field Selection screen. Clover automatically adds the subtotals to each level break and at the end of the report. Subtotals and record counters can also be added with a creation wizard directly in the HTML or with the right click short cut.

Create calculated fields by using the basic and advanced SQL function from the Calculated Fields wizard. Select from scalar functions like substring to create derived fields or from columnar functions like sum or count to create summary fields.