Set-TRExport

Synopsis

Used to set the export format of the report job.

Syntax

Set-TRExport [<CommonParameters>]

Set-TRExport [-Csv] <SwitchParameter> [-UseTab] [[-Delimiter] <String>] [[-Separator] <String>] [[-CsvMode] <String> {Legacy | Standard} ] [[-CsvGroupSections] <String> {Export | Omit | Issolated} ] [[-CsvReportSections] <String> {Export | Omit | Issolated} ] [<CommonParameters>]

Set-TRExport -Csv <SwitchParameter> [<CommonParameters>]

Set-TRExport [-Pdf] <SwitchParameter> [-FirstPage] <Int32> [-LastPage] <Int32> [-CreateBookmarks] [<CommonParameters>]

Set-TRExport -Pdf <SwitchParameter> [-CreateBookmarks] [<CommonParameters>]

Set-TRExport [-Document] <SwitchParameter> [[-FirstPage] <Int32>] [[-LastPage] <Int32>] [<CommonParameters>]

Set-TRExport [-RichText] <SwitchParameter> [-PageBreaks] [[-FirstPage] <Int32>] [[-LastPage] <Int32>] [<CommonParameters>]

Set-TRExport [-Html32] <SwitchParameter> [[-BaseFolderName] <String>] [[-FileName] <String>] [-EnableSeperatePages] [-PageNavigator] [[-FirstPage] <Int32>] [[-LastPage] <Int32>] [<CommonParameters>]

Set-TRExport [-Html40] <SwitchParameter> [[-BaseFolderName] <String>] [[-FileName] <String>] [-EnableSeperatePages] [-PageNavigator] [[-FirstPage] <Int32>] [[-LastPage] <Int32>] [<CommonParameters>]

Set-TRExport [-Report] [<CommonParameters>]

Set-TRExport [-ReportReadOnly] [<CommonParameters>]

Set-TRExport [-TabSeperatedValues] <SwitchParameter> [<CommonParameters>]

Set-TRExport [-Text] <SwitchParameter> [[-CharactersPerInch] <Int32>] [[-LinesPerPage] <Int32>] [<CommonParameters>]

Set-TRExport [-Xml] <SwitchParameter> [<CommonParameters>]

Set-TRExport -ExcelWorkbook <SwitchParameter> [<CommonParameters>]

Set-TRExport [-ExcelWorkbook] <SwitchParameter> [-ShowOutlines] [-SimplifyPageHeaders] [-UseWorksheetFunctionsForSummaries] [-PreserveColumnAlignment] [-PreserveRelativeObjectPosition] [-PreserveObjectFormatting] [-PreservePageHeaderAndFooter] [-ExportImages] [-UseConstantColumnWidth] [-ConstantColumnWidth <Double>] [-Section <String> {Detail | WholeReport | GroupHeader | GroupFooter | PageHeader | PageFooter | ReportHeader | ReportFooter} ] [-GroupNumber <Int16>] [<CommonParameters>]

Set-TRExport -ExcelRecord <SwitchParameter> [<CommonParameters>]

Set-TRExport [-ExcelRecord] <SwitchParameter> [-ShowOutlines] [-SimplifyPageHeaders] [-UseWorksheetFunctionsForSummaries] [-PreserveColumnAlignment] [-PreserveRelativeObjectPosition] [-PreserveObjectFormatting] [-PreservePageHeaderAndFooter] [-ExportImages] [-UseConstantColumnWidth] [-ConstantColumnWidth <Double>] [-Section <String> {Detail | WholeReport | GroupHeader | GroupFooter | PageHeader | PageFooter | ReportHeader | ReportFooter} ] [-GroupNumber <Int16>] [[-FirstPage] <Int32>] [[-LastPage] <Int32>] [<CommonParameters>]

Set-TRExport -Excel <SwitchParameter> [<CommonParameters>]

Set-TRExport [-Excel] <SwitchParameter> [-ShowOutlines] [-UseConstantColumnWidth] [-ConstantColumnWidth <Double>] [-PageBreaksForEachPage <Boolean>] [-ExportPageHeadersAndFooters <String> {Once | EachPage | None} ] [-Section <String> {Detail | WholeReport | GroupHeader | GroupFooter | PageHeader | PageFooter | ReportHeader | ReportFooter} ] [-GroupNumber <Int16>] [<CommonParameters>]

Description

If you only use only an export type flag (e.g. -Pdf or - Csv), the system will use the default export settings that are saved by the report. Change these defaults by editing the default export settings inside the report.

Parameters

-Csv <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-UseTab <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Delimiter <String>

Required?	False
Position?	1
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Separator <String>

Required?	False
Position?	2
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-CsvMode <String>

Required?	False
Position?	3
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-CsvGroupSections <String>

Required?	False
Position?	4
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-CsvReportSections <String>

Required?	False
Position?	5
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Pdf <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-FirstPage <Int32>

Required?	True
Position?	1
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-LastPage <Int32>

Required?	True
Position?	2
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-CreateBookmarks <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Document <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-RichText <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PageBreaks <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Html32 <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-BaseFolderName <String>

Required?	False
Position?	3
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-FileName <String>

Required?	False
Position?	4
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-EnableSeperatePages <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PageNavigator <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Html40 <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Report <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ReportReadOnly <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-TabSeperatedValues <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Text <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-CharactersPerInch <Int32>

Required?	False
Position?	1
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-LinesPerPage <Int32>

Required?	False
Position?	2
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Xml <SwitchParameter>

Required?	True
Position?	0
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ExcelWorkbook <SwitchParameter>

Required?	True
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ShowOutlines <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-SimplifyPageHeaders <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-UseWorksheetFunctionsForSummaries <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PreserveColumnAlignment <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PreserveRelativeObjectPosition <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PreserveObjectFormatting <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PreservePageHeaderAndFooter <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ExportImages <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-UseConstantColumnWidth <SwitchParameter>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ConstantColumnWidth <Double>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Section <String>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-GroupNumber <Int16>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ExcelRecord <SwitchParameter>

Required?	True
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-Excel <SwitchParameter>

Required?	True
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-PageBreaksForEachPage <Boolean>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

-ExportPageHeadersAndFooters <String>

Required?	False
Position?	named
Default value
Accept pipeline input?	false
Accept wildcard characters?	False

<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).

Inputs

Outputs

Notes

Examples

Related links

The Report Processor Documentation