Specifications

Contents
Users Guide vii
Selecting a data source................................................................ 154
Using Quick Select....................................................................... 156
Selecting a table.................................................................... 157
Selecting columns ................................................................. 158
Specifying sorting criteria ...................................................... 159
Specifying selection criteria................................................... 159
Using SQL Select......................................................................... 165
Selecting tables and views.................................................... 166
Selecting columns ................................................................. 168
Displaying the underlying SQL statement ............................. 169
Joining tables ........................................................................ 170
Using retrieval arguments ..................................................... 173
Referencing retrieval arguments ........................................... 174
Specifying selection, sorting, and grouping criteria ............... 175
Using Query ................................................................................. 180
Using External.............................................................................. 180
Using Stored Procedure............................................................... 182
Choosing report-wide options ...................................................... 184
Generating and saving a report.................................................... 185
About the extended attribute system tables and reports....... 185
Saving the report................................................................... 187
Modifying an existing report .................................................. 187
Defining queries ........................................................................... 188
Previewing the query............................................................. 188
Saving the query ................................................................... 189
Modifying a query.................................................................. 190
What's next................................................................................... 190
CHAPTER 6 Enhancing Reports..................................................................... 191
Working in the Report painter ...................................................... 192
Understanding the Report painter Design view..................... 194
Using the Report painter toolbars.......................................... 196
Using the Properties view in the Report painter.................... 197
Selecting controls in the Report painter ................................ 197
Resizing bands in the Report painter Design view................ 199
Using zoom in the Report painter.......................................... 199
Undoing changes in the Report painter................................. 199
Using the Preview view of a report............................................... 200
Retrieving data ...................................................................... 200
Modifying data....................................................................... 202
Importing data into a report ................................................... 203
Using print preview................................................................ 204
Printing data .......................................................................... 206
Working in a grid report ......................................................... 207