--
Dim Filter As String
Dim dr As DataRow = e.Node.DataRow \'获取生成此节点的行
If e.Node.Text <> "显示所有行" Then
Select Case e.Node.Level
Case 0
Filter = "[月份] = \'" & dr("月份") & "\'"
Case 1
Filter = "[月份] = \'" & dr("月份") & "\' And [业务分类] = \'" & dr("业务分类") & "\'"
Case 2
Filter = "[月份] = \'" & dr("月份") & "\' And [业务分类] = \'" & dr("业务分类") & "\' And [客户名称] = \'" & dr("客户名称") & "\'"
Case 3
Filter = "[月份] = \'" & dr("月份") & "\' And [业务分类] = \'" & dr("业务分类") & "\' And [客户名称] = \'" & dr("客户名称") & "\'And [业务类型] = \'" & dr("业务类型") & "\'"
End Select
End If
Tables("开票申请").Filter = Filter