Saving data in an external file

While previewing, you can save the data retrieved in an external file. Note that the data and headers (if specified) are saved. Information in the footer or summary bands is not saved unless you are saving the data to a Powersoft report.

The file format you select for the external file determines whether PocketBuilder saves the data using ANSI or Unicode character sets.

For information about the relation between the file format you select and the character set in which data is saved, see the chapter on working with Unicode in the Resource Guide.

Saving the data in HTML Table format

One of the external file formats you can save data in is the HTML Table format. When you save in HTML Table format, PocketBuilder saves a style sheet along with the data. If you use this format, you can open the saved file in a Web browser. Once you have the file in HTML Table format, you can continue to enhance the file in HTML.

StepsTo save the data in a DataWindow object in an external file:

  1. Select File>Save Rows As from the menu bar.

    The Save As dialog box displays.

  2. Choose a format for the file from the Save As Type drop-down list.

    If you want the column headers saved in the file, select a file format that includes headers (such as Excel With Headers). When you select a format with headers, the names of the database columns (not the column labels) are also saved in the file.

    When you choose a format, PocketBuilder supplies the appropriate file extension.

  3. Name the file and click Save.

    PocketBuilder saves all displayed rows in the file; all columns in the displayed rows are saved. Filtered rows are not saved.