setDelimitedFileOptions(fieldSeparator: Character; fieldDelimiter: Character; extractGroupHeaders: Boolean; extractGroupFooters: Boolean; extractReportHeaders: Boolean; extractReportFooters: Boolean; combineGroupsAndDetail: Boolean; formatDates: Boolean; formatNumerics: Boolean);
The setDelimitedFileOptions method of the JadeReportWriterReport class sets the values to be used when running the report for extraction to a delimited file. (Use the getDelimitedFileOptions method to obtain the current values set up for a delimited file.)
The parameters for the setDelimitedFileOptions method are listed in the following table.
Parameter | Description |
---|---|
fieldSeparator | Specifies the delimiter that is used between each field of data (for example, a comma or a tab character) |
fieldDelimiter | Specifies the character that is placed around each non-null field (typically a quote (‘) character) |
extractGroupHeaders | Specifies whether group header data is extracted to the output file |
extractGroupFooters | Specifies whether group footer data is extracted to the output file |
extractReportHeaders | Specifies whether report header data is extracted to the output file |
extractReportFooters | Specifies whether report footer data is extracted to the output file |
combineGroupsAndDetail | Specifies whether group header and detail fields are combined into one record |
formatDates | Specifies whether date fields are written as formatted strings as they are for a printed report (when true) or as a numeric value (when false) |
formatNumerics | Specifies whether numeric fields are written as formatted strings as they are for a printed report (when true) or as unformatted numeric values (when false) |
If the values of both the combineGroupsAndDetail and extractGroupHeaders parameters are true, each extract record contains the group header fields in order and then the detail fields combined into one record. If both the combineGroupsAndDetail and extractGroupHeaders parameters are not set to true and the extractGroupHeaders or extractGroupFooters parameter is set to true, group data is extracted as separate records.