Back to Top

Set-TRExport

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