setDelimitedFileOptions

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.