Formatting Result Sets

Go Up to Using the Results Editor

The ISQL Editor provides flexibility in formatting result sets, for analysis and reporting, from within a Result Window. Result sets can be formatted to best suit your purpose, whether it be sending via e-mail, printing, or exporting a file to other programs, such as Microsoft Excel. Some of these features change only the screen display of the results, while others allow you to format for printing.

• Changing the Displayed View
• Format Border Styles
• Format Font Styles
• Format Color Styles

For information on general appearance of results, see Configuring Results Window Grid Properties.

Changing the Displayed View

You can view results in a standard grid, in HTML format, or as flat ASCII. By default, when a result window is generated, the results are displayed according to the view option currently selected on the Results (ISQL) Options. You can change the display in the results window.

To change the result view on the fly:

1. Right-click in the results window.
2. On the shortcut menu, choose one of the View as Grid, View as HTML, or View as ASCII options.

Format Border Styles

You can use the shortcut menu to alter border properties.

Completing the Format Styles Dialog Box

To complete the Format Styles dialog, do the following:

1. Right-click the Result data grid, and then click Border.
2. On the Border box, you can indicate whether or not a border should appear on the top, bottom, right, left, or for a range of cells by clicking the corresponding boxes.
3. To set a range of cells apart by setting a particular border style around that range, select the range in the result set before opening the Format Styles dialog. To select the Range property, click the range box.
4. In the Type box, you can select the type of line you want to border the cell or cells by clicking the corresponding boxes.
5. To select a color, click the Color list, and then click the border color.
6. Click OK.

   Changes are saved and the Format Styles dialog closes.

Format Font Styles

You can use the shortcut menu to alter font properties. Selecting the Font command displays the Format Styles tabbed dialog.

Completing the Format Styles Dialog Box

To complete the Format Styles dialog, do the following:

1. Right-click the Result data grid, and then click Font.

   The Format Styles dialog opens.

2. In the Font box, type or click the font you want to use.
3. In the Style box, type or click the font style you want to use.
4. In the Size box, type or click the size you want to use.
5. To make a line cross through the length of the text, in the Effects box, select the Strikeout check box.
6. To underline the text, in the Effects box, select the Underline check box.
7. To change the script style, click the Script list, and then click the new script style.

   The Sample box displays the sample text of your selections

Format Color Styles

You can use the shortcut menu to alter color properties. Selecting the Color command displays the Cell Properties dialog.

Completing the Cell Properties Dialog Box

To complete the Format Styles dialog, do the following:

1. Right-click the Result data grid, and then click Color.

   The Cell Properties dialog opens.

2. Change the Text Color and Background Color options.