1C:Enterprise | 1C:Enterprise Developer's Community

ReportBuilder

Properties:

AppearanceTemplate
AutoDetailRecords
AvailableFields
ColumnDimensions
ConditionalAppearance
DataSource
DetailFillType
DetailRecordsTemplate
DimensionAttributePlacementInColumns
DimensionAttributePlacementInRows
DimensionsPlacementOnColumns
DimensionsPlacementOnRows
Filter
HeaderText
Order
OverallsTemplate
Parameters
PresentationAdding
ProcessUserInterruption
PutDetailRecords
PutOveralls
PutReportFooter
PutReportHeader
PutTableFooter
PutTableHeader
ReportFooterTemplate
ReportHeaderTemplate
Result
RowDimensions
SelectedFields
ShowStatus
TableFooterTemplate
TableHeaderTemplate
Template
Text
TotalsPlacementOnColumns
TotalsPlacementOnRows

Methods:

ApplyAppearanceTemplate
Execute
FillSettings
GetQuery
GetSettings
InitDetails
Put
SetSettings

Constructors:

Initialization of the report builder by text of the request

Description:

You can use it for intellectual building the reports.

Availability:

Server, thick client, external connection.

Example:

// Querytext - control, in which the query is generated
//  (For example, using the query builder)
Builder = New ReportBuilder;
Try
    Builder.Text = Controls.QueryText.GetText();
    Builder.Execute();
    If ResultInSpreadsheetDocument Then
        // Output results into a spreadsheet document
        Builder.Put();
    Else
        // Into a pivot table
        PivotTable.DataSource = Builder;
        PivotTable.Refresh();
    EndIf;
Except
    DoMessageBox(ErrorDescription());
EndTry;