## Report Options dialog box

This dialog box appears when you choose the Report Options command from the File menu.

Note: These options also appear in the Options dialog box. Use the Options dialog box to change the default values for the program, use the Report Options dialog box to change the options for the current report.

##### Convert Date-Time Field

Using this list, specify if you want Date/Time string fields from Microsoft Access automatically converted to:

- string format
- date format
- date-time format.

##### Preview Pages Start With

This list enables you to select the default level of magnification for displaying reports on the Preview tab.

- Full Size
  Full size allows you to view your report at the highest magnification for easy reading. The page is larger than a standard VGA Preview tab. When you resize the Preview tab, the report size remains unchanged. All that changes is the amount of the report you can view at one time. You may need to use scroll bars to see all sections of your report.
- Fit Width
  Fit Width adjusts the width of the report to the width of the Preview tab. When you resize the Preview tab (within realistic limits), the page image resizes as well. To see a larger image, you can expand the window.
- Fit Page
  Fit Page adjusts the width and the length of the report to let you see a full page of your report in the Preview tab. When you resize the Preview tab (within realistic limits), the page image resizes as well. To see a larger image, you can expand the window.

By default, the selector is set to Fit Width.

Note: All of the functions available in the Preview tab are available at every magnification.

##### Convert NULL Field to Default

Selecting this check box forces the program to convert any null values to the database field default. Some databases treat a null as zero, some as a blank, and some as a special null value.

##### Translate DOS Strings

This option is like the Translate DOS Memos option. The only difference is that it is active for string fields instead of memo fields.

Note: If this check box is not selected and you have used upper ASCII characters in your dBASE string fields, the special characters will not be the same in your report as they are in the dBASE string field.

By default, the Translate DOS Strings check box is selected.

##### Translate DOS Memos

When you insert special characters in dBASE memo fields, you use the upper ASCII character set (those characters with decimal values between 128 and 255). When you insert special characters into Windows programs, you use ANSI codes to do so. If you include upper ASCII characters in dBASE memo fields and then use those fields to create a reports, the program would read the codes and assume they were ANSI codes were it not for the Translate DOS Memos option.

- When Translate DOS Memos is activated (a check in the check box), the program assumes that any character code it finds is an ASCII code and it translates that code to a corresponding ANSI value so the same character that appears in dBASE appears in your report.
- When the option is not checked, the program assumes that any character code it finds is already an ANSI code and it does no further translation.

Note: If this check box is not selected and you have used upper ASCII characters in your dBASE memo fields, the special characters will not be the same in your report as they are in the dBASE memo field.

By default, the Translate DOS Memos check box is selected.

##### Save Data with Report

Select this check box to save the current data with the report.

##### Save Summaries with Report

Select this check box to save summary information with your report.

##### Cartesian Product

Use this check box to produce all possible combinations of the original data. This option is not selected by default.

Note: The Cartesian Product option applies to OLAP data sources and does not apply specifically to other direct access data sources. The option ensures a report shows all values of all dimensions (as opposed to all values of the first dimension by one value of the second dimension, which would be the result if the option was not selected).

##### Perform Query Asynchronously

When this check box is selected, the program uses asynchronous queries. The program normally sends an entire query to the database server. Selecting this option, however, allows the program and the ODBC database server (if it supports asynchronous queries) to transfer data back and forth. An advantage of using this option is you can cancel queries during processing more easily. This option is not selected by default.

##### Suppress Printing If No Records

Select this option to suppress the printing of a report if that report does not contain any records.

##### Show All Headers on Drill Down

Use this check box if you would like report drill-down views to included headers for all sections above the drill-down records. This option is not selected by default.

##### Use Indexes Or Server for Speed

When you select this check box, the program uses available indexes/servers to speed the record selection process.

When you clear this check box, the program selects records without the use of indexes/specified servers (a much slower process).

Note: If an index has a different name than the database it indexes, you need to identify the index for the program. You do this using the Link Options dialog box, which is accessed from the Visual Linking Expert.

##### Perform Grouping On Server

This check box is only available if the Use Indexes or Server For Speed check box is selected.

Select this check box to have the program perform grouping on the server (server-side processing). Server-side processing allows you to set up a report that performs the majority of its processing on the server and pushes only relevant details to your computer. Server-side processing provides you with a number of benefits:

- less time connected to the server
- less memory needed to process the report on your computer
- lower transfer time from the server to the client.

Server-side processing works only for reports based on SQL data sources (you cannot, for example, use server-side processing for a report based on a query, since a query is not an SQL data source).

This option is not selected by default.

###### Related topics

Server-side processing

##### More Report Engine Error Messages

Using this check box tells the program to use more verbose error messages when a Report Engine error occurs.

##### Case Insensitive SQL Data

This check box specifies whether or not the SQL data you use in the report becomes case sensitive. If the data you are using contains fields where the data is in both upper case and lower case, and you do not wish to categorize the data by this aspect, select this check box.

Note: Case Sensitive SQL data is not supported in the 32-bit standard edition of the program.

##### Select Distinct Records

Use this option to select only unique records from SQL tables in your database. By selecting this option in the Report Options dialog box, you set the option for the current report. Alternatively, you can set the option for all reports by switching on the Select Distinct Records command on the Database menu.

##### Select Distinct Data for Browsing

When you browse a field, by default you see the first 500 unique values of the field. You can change this for the current report by clearing this option. If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records.

Note: Note that since most SQL servers do not support selecting distinct records for long data types such as memo and blob fields, selecting and browsing distinct records are not supported for such fields.

##### Create Group Tree

Select this check box to create a Group Tree for use in the Preview tab. Using the Group Tree view, you can drill-down on group data.

###### Related topics

Report Options command

Options dialog box

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com