老师,是这一段代码有错,总表A中,HTH、年度是列,一季度利息、二季度利息、三季度利息、四季度利息是多层表头,对应明细表C,表C有HTH、年度、季度列,现在是HTH、年度对应了,季度利息不对应,就是表C季度列要对应表A的四列。请问怎么处理啊。
If e.DataCol.Name = "HTH" Then
Dim filter1 As String
Dim filter2 As String = "HTH = '" & e.DataRow("HTH") & "' And 年度 = '" & e.DataRow("年度") & "'"
e.DataRow("一季度利息") = DataTables("支付利息").Compute("sum(LX)",filter2 And filter1 = "一季度")
e.DataRow("二季度利息") = DataTables("支付利息").Compute("sum(LX)",filter2 And filter1 = "二季度")
e.DataRow("三季度利息") = DataTables("支付利息").Compute("sum(LX)",filter2 And filter1 = "三季度")
e.DataRow("四季度利息") = DataTables("支付利息").Compute("sum(LX)",filter2 And filter1 = "四季度")
End If