or
Partial
Public
Class
RwpInstructions
Inherits
Telerik.Reporting.Report
Public
Sub
New
()
InitializeComponent()
Dim
cs
As
New
ConnString
Me
.SqlDataSource1.ConnectionString = cs.AAIOMSConnString()
End
Sub
Public
Property
setWorkOrderID()
As
Integer
Get
Return
CInt
(
Me
.SqlDataSource1.Parameters.Item(
"@WorkOrderID"
).Value)
End
Get
Set
(
ByVal
workOrderID
As
Integer
)
Me
.SqlDataSource1.Parameters(
"@WorkOrderID"
).Value = workOrderID
End
Set
End
Property
End
Class
Hi Support Team,
I am using Telerik reporting V4.2
|
Value |
Vertical Relevance (%) |
200 |
20 |
|
300 |
30 |
|
500 |
50 |
|
Total |
1000 |
100 |
I want to calculate vertical relevance field as shown in above.
Formula:
Vertical relevance = (Value/ Total value) * 100
Example: (of first row)
20% = (200/1000) * 100
I am get not sum (total value = 1000) at row level, it return 200 for total.
Please help me to calculate Vertical relevance.
Thanks in advance for support.
- Kalpesh
Private Sub chtDefectsByFamily_ItemDataBound(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chtDefectsByFamily.ItemDataBound |
Dim ChartItem As Telerik.Reporting.Processing.Chart = DirectCast(sender, Telerik.Reporting.Processing.Chart) |
Dim ci As Telerik.Reporting.Chart = TryCast(ChartItem.ItemDefinition, Telerik.Reporting.Chart) |
For Each seriesItem As Telerik.Reporting.Charting.ChartSeries In ci.Series |
seriesItem.Appearance.LabelAppearance.LabelLocation = Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside |
seriesItem.Appearance.TextAppearance.TextProperties.Color = Color.White |
For Each serieItem As Telerik.Reporting.Charting.ChartSeriesItem In seriesItem.Items |
If serieItem.YValue = 0 Then |
serieItem.Label.Visible = False |
End If |
serieItem.SetDirty() |
Next |
seriesItem.SetDirty() |
Next |
End Sub |