To create and add a chart to a report

Parent Previous Next

 

Report Application Server .NET SDK Developer Guide

To create and add a chart to a report


 







  1. Create a new ChartDefinition object and set its type.

Visual Basic

Dim myChartDefinition As ChartDefinition = New ChartDefinitionClass()
myChartDefinition.ChartType = CrChartTypeEnum.crChartTypeGroup

C#

ChartDefinition chartDefinition = new ChartDefinitionClass();
chartDefinition.ChartType = CrChartTypeEnum.crChartTypeGroup;

  1. Get the conditional field of the report's first group and set the field using the setConditonalFields method.

Visual Basic

Dim myDataDef As DataDefinition = clientDoc.DataDefController.DataDefinition
Dim conditionFields As Fields = New FieldsClass
Dim field As ISCRField = myDataDef.DataDefinition.Groups.Item(1).ConditionField
conditionFields.Add(field)
myChartDefinition.ConditionFields = conditionFields

C#

DataDefinition dataDefinition = rcd.DataDefController.DataDefinition;
Fields conditionFields = new FieldsClass();
ISCRField field = dataDefinition.Groups[0].ConditionField;
conditionFields.Add(field);
chartDefinition.ConditionFields = conditionFields;

  1. Loop through the report's summary fields until the one matching the specified name is found, and set the summary field of the ChartDefinition object using the setDataFields method.

Visual Basic

Dim dataFields As Fields = New FieldsClass
Dim summaryFields As Fields = clientDoc.DataDefController.DataDefinition.SummaryFields
Dim summaryField As ISCRField
For Each summaryField In summaryFields
 dataFields.Add(summaryField)
Next
myChartDefinition.DataFields = dataFields

C#

Fields dataFields = new FieldsClass();
Fields summaryFields = rcd.DataDefController.DataDefinition.SummaryFields;
foreach (ISCRField summaryField in summaryFields)
{ dataFields.Add(summaryField); }
chartDefinition.DataFields = dataFields;

  1. Create a new ChartObject to represent the chart that will be added and set the ChartDefinition property.

Visual Basic

ChartObject chartObject = new ChartObjectClass();
chartObject.ChartDefinition = chartDefinition;

C#

ChartObject chartObject = new ChartObjectClass();
chartObject.ChartDefinition = chartDefinition;

  1. Set the chart type, chart placement, and chart title.

Visual Basic

myChartObject.ChartStyle.Type = CrChartStyleTypeEnum.crChartStyleTypePie
myChartObject.ChartReportArea = CrAreaSectionKindEnum.crAreaSectionKindReportHeader
myChartObject.ChartStyle.TextOptions.Title = chartTitle

C#

chartObject.ChartStyle.Type = CrChartStyleTypeEnum.crChartStyleTypePie;
chartObject.ChartReportArea = CrAreaSectionKindEnum.crAreaSectionKindReportHeader;
chartObject.ChartStyle.TextOptions.Title = chartTitle;

  1. Set the width, height, and top of the chart.

Visual Basic

myChartObject.Height = 5000
myChartObject.Width = 5000
myChartObject.Top = 1000

C#

chartObject.Height = 5000;
chartObject.Width = 5000;
chartObject.Top = 1000;

  1. Add the chart to a section in the report using the ReportDefController object.

Visual Basic

Dim area As ISCRArea = clientDoc.ReportDefController.ReportDefinition.ReportHeaderArea
Dim sectionToAddTo As Section = CType(area.Sections(0), Section)
clientDoc.ReportDefController.ReportObjectController.Add(myChartObject, sectionToAddTo, 1)

C#

ISCRArea area = rcd.ReportDefController.ReportDefinition.ReportHeaderArea;
Section sectionToAddTo = (Section)area.Sections[0];
rcd.ReportDefController.ReportObjectController.Add(chartObject, sectionToAddTo, 1);

This sample creates and adds a pie chart to the header section of a report.

Visual Basic

Private Sub AddChart(ByVal cientDoc As ReportClientDocument, ByVal chartTitle As String)
  Dim myChartDefinition As ChartDefinition = New ChartDefinitionClass()
  myChartDefinition.ChartType = CrChartTypeEnum.crChartTypeGroup
  Dim myDataDef As DataDefinition = clientDoc.DataDefController.DataDefinition
  Dim conditionFields As Fields = New FieldsClass
  Dim field As ISCRField = myDataDef.DataDefinition.Groups.Item(1).ConditionField
  conditionFields.Add(field)
  myChartDefinition.ConditionFields = conditionFields
  Dim dataFields As Fields = New FieldsClass
  Dim summaryFields As Fields = clientDoc.DataDefController.DataDefinition.SummaryFields
  Dim summaryField As ISCRField
  For Each summaryField In summaryFields
       dataFields.Add(summaryField)
  Next
  myChartDefinition.DataFields = dataFields
  Dim myChartObject As ChartObject = New ChartObjectClass
  myChartObject.ChartDefinition = myChartDefinition
  myChartObject.ChartStyle.Type = CrChartStyleTypeEnum.crChartStyleTypePie
  myChartObject.ChartReportArea = CrAreaSectionKindEnum.crAreaSectionKindReportHeader
  myChartObject.ChartStyle.TextOptions.Title = chartTitle
  myChartObject.Height = 5000
  myChartObject.Width = 5000
  myChartObject.Top = 1000
  Dim area As ISCRArea = clientDoc.ReportDefController.ReportDefinition.ReportHeaderArea
  Dim sectionToAddTo As Section = CType(area.Sections(0), Section)
  clientDoc.ReportDefController.ReportObjectController.Add(myChartObject, sectionToAddTo, 1)
End Sub

C#

private void AddChart(ISCDReportClientDocument rcd, string chartTitle)
{
 ChartDefinition chartDefinition = new ChartDefinitionClass();
 chartDefinition.ChartType = CrChartTypeEnum.crChartTypeGroup;
 DataDefinition dataDefinition = rcd.DataDefController.DataDefinition;
 Fields conditionFields = new FieldsClass();
 ISCRField field = dataDefinition.Groups[0].ConditionField;
 conditionFields.Add(field);
 chartDefinition.ConditionFields = conditionFields;
 Fields dataFields = new FieldsClass();
 Fields summaryFields = rcd.DataDefController.DataDefinition.SummaryFields;
 foreach (ISCRField summaryField in summaryFields)
 { dataFields.Add(summaryField); }
 chartDefinition.DataFields = dataFields;
 ChartObject chartObject = new ChartObjectClass();
 chartObject.ChartDefinition = chartDefinition;
 chartObject.ChartStyle.Type = CrChartStyleTypeEnum.crChartStyleTypePie;
 chartObject.ChartReportArea = CrAreaSectionKindEnum.crAreaSectionKindReportHeader;
 chartObject.ChartStyle.TextOptions.Title = chartTitle;
 chartObject.Height = 5000; 
 chartObject.Width = 5000;
 chartObject.Top = 1000;
 ISCRArea area = rcd.ReportDefController.ReportDefinition.ReportHeaderArea;
 Section sectionToAddTo = (Section)area.Sections[0];
 rcd.ReportDefController.ReportObjectController.Add(chartObject, sectionToAddTo, 1);
}

This list includes the namespaces used by the sample code:

© 2021 SAP AG. All rights reserved.

http://www.sap.com/sapbusinessobjects/

Support services

http://service.sap.com/bosap-support/

Created with the Personal Edition of HelpNDoc: Free HTML Help documentation generator