Sets the output properties of the report based on the parameters passed. Call this before calling CreateOutput.

Syntax

SetOutputToFile(FileName as String [, Type as String
    [, SubType as String]]) as Boolean

Parameters
FileName
The name and path of the file to output the report to. If the file already exists, it's overwritten.

Type
The type of file to create. This is the same as a file extension: "PDF" for a PDF file, "XLS" for a Microsoft Excel file, "DOC" for a Microsoft Word file, "HTML" for an HTML file, and so forth (see the Output Options topic in the Stonefield Query help file for a list of the file types supported). If it isn't specified, the file type is taken from the extension of the specified file name.

SubType
Since Stonefield Query can output either data-only or full format for Microsoft Excel, specify the type of file you want if you output to Excel: "full" for full format, "data" for data-only, or "fast" for fast data-only. If this isn't specified, "data" is assumed.

Return Value
True if the parameters were correct or False if not.

See also

CreateOutput | Report Object

© Stonefield Software Inc., 2023 • Updated: 02/10/17
Comment or report problem with topic