Specifications

Using Query
180 InfoMaker
❖ To define HAVING criteria:
• Click the Having tab to make the Having view available (or select
View>Having if the Having view is not currently displayed).
Each row in the Having view is a place for entering an expression that
limits which groups are retrieved. For information on how to define
criteria in the Having view, see the procedure in “Defining WHERE
criteria” on page 176.
Using Query
When you choose Query as the data source, you select a predefined SQL
SELECT statement (a query) as specifying the data for your report.
❖ To define the data using Query:
1 While using any of the report wizards, click Query in the Choose Data
Source dialog box, and click Next.
The Select Query dialog box displays.
2 Type the name of a query or use the Browse button to find the query, then
click Next.
3 Finish interacting with the report wizard as needed for the presentation
style you are using.
To learn how to create queries, see “Defining queries” on page 188.
Using External
If the data for the report does not come from a database (either through a native
Sybase database interface or through a standard database interface), specify
External as the data source. You then specify the data columns and their types
so InfoMaker can build the appropriate report to hold the data. These columns
make up the result set. InfoMaker places the columns you specified in the result
set in the report.