Name 'Sum' is not declared". Sum function works in V2 not in V3
Posted: Wed Feb 06, 2008 11:32 am
I was using Sum function in my reports
In Version: 2007.2 from 4 September 2007 everything works fine
Public Function Text33_GetValue_End(ByVal component As Stimulsoft.Report.Components.StiComponent) As System.String
Return Me.Text33.TextFormat.Format(IIF(CType(StiReport.ChangeType(Me.Text33_Sum1.GetValue, GetType(System.Decimal), true),Decimal)>0,CType(StiReport.ChangeType(Me.Text33_Sum2.GetValue, GetType(System.Decimal), true),Decimal),"-"))
End Function
But when I open the same report In Version 2007.3.100 from 11 Devember 2007 it gives me error
"C:\DOCUNE~1\tEMP\PCQHGPG9.0.VB(376.0) : error BC30451 : Name 'Sum' is not declared"
Public Function Text33_GetValue_End(ByVal sender As Stimulsoft.Report.Components.StiComponent) As System.String
Return Me.Text33.TextFormat.Format(CheckExcelValue(sender, IIF(Sum(BG_PSSUNPOS_SELECT_RPT.Agency_Position_Count1)>0,CType(StiReport.ChangeType(Me.Text33_Sum2.GetValue, GetType(System.Decimal), true),Decimal),"-")))
End Function
Please help
In Version: 2007.2 from 4 September 2007 everything works fine
Public Function Text33_GetValue_End(ByVal component As Stimulsoft.Report.Components.StiComponent) As System.String
Return Me.Text33.TextFormat.Format(IIF(CType(StiReport.ChangeType(Me.Text33_Sum1.GetValue, GetType(System.Decimal), true),Decimal)>0,CType(StiReport.ChangeType(Me.Text33_Sum2.GetValue, GetType(System.Decimal), true),Decimal),"-"))
End Function
But when I open the same report In Version 2007.3.100 from 11 Devember 2007 it gives me error
"C:\DOCUNE~1\tEMP\PCQHGPG9.0.VB(376.0) : error BC30451 : Name 'Sum' is not declared"
Public Function Text33_GetValue_End(ByVal sender As Stimulsoft.Report.Components.StiComponent) As System.String
Return Me.Text33.TextFormat.Format(CheckExcelValue(sender, IIF(Sum(BG_PSSUNPOS_SELECT_RPT.Agency_Position_Count1)>0,CType(StiReport.ChangeType(Me.Text33_Sum2.GetValue, GetType(System.Decimal), true),Decimal),"-")))
End Function
Please help