Dim Total As Integer
Total = ListBox_up.Items.Count
If Total > 9 Then Total = 9
For i = 0 To Total - 1
'************************************************************************************************
'///////////公式选定字段
Dim Check As String = "select id from 数据结构 where 数据表id=446 and 字段类型='System.DateTime' and id='" & ListBox_up.Items(i).Value & "'"
Dim V_Check As New sys_DataSource("数据结构", Check, True)
If V_Check.dbDataset.Tables(0).Rows.Count > 0 Then
rpt.DataDefinition.FormulaFields("f" & (i + 1).ToString).Text = "Cstr({员工基本信息." & ListBox_up.Items(i).Text & "},'yyyy/M/dd')"
Else
rpt.DataDefinition.FormulaFields("f" & (i + 1).ToString).Text = "{员工基本信息." & ListBox_up.Items(i).Text & "}"
End If
V_Check.close()
'////////////////////////////////////////////////////////////////////////////////////////////////
'Dim section As CrystalDecisions.CrystalReports.Engine.Section
'section = rpt.ReportDefinition.Sections("DetailSection1")
'Dim fieldObject As CrystalDecisions.CrystalReports.Engine.FieldObject
'If TypeOf (section.ReportObjects("f" & (i + 1).ToString & "1")) Is CrystalDecisions.CrystalReports.Engine.FieldObject Then
' fieldObject = section.ReportObjects("f" & (i + 1).ToString & "1")
' If TypeOf (fieldObject) Is CrystalDecisions.CrystalReports.Engine.FieldObject Then
' 'fieldObject.Left = CInt(11520 * i / Total)
' 'If i = 0 Then fieldObject.Left = fieldObject.Left + 100
' Else
' Response.Write("<script>alert('内容!')</script>")
' Exit Sub
' End If
'End If
''************************************************************************************************
' ///////////标题的位置 PageHeaderSection1
Dim section2 As CrystalDecisions.CrystalReports.Engine.Section
section2 = rpt.ReportDefinition.Sections("PageHeaderSection1")
If TypeOf (section2.ReportObjects("text" & (1 + i).ToString)) Is CrystalDecisions.CrystalReports.Engine.TextObject Then
Dim txtObj As CrystalDecisions.CrystalReports.Engine.TextObject
txtObj = rpt.ReportDefinition.Sections("PageHeaderSection1").ReportObjects("text" & (1 + i).ToString)
If TypeOf (txtObj) Is CrystalDecisions.CrystalReports.Engine.TextObject Then
txtObj.Text = ListBox_up.Items(i).Text.ToString
' 'txtObj.Left = CInt(11520 * i / Total)
' 'If i = 0 Then txtObj.Left = txtObj.Left + 100
'Else
' Response.Write("<script>alert('标题!')</script>")
' Exit Sub
End If
End If
Next
rptViewer.ReportSource = rpt
rptViewer.DisplayGroupTree = False
rptViewer.RefreshReport()
[Visual Basic]
' 声明将参数传递给
'查看器控件所需的变量。
Dim paramFields As New ParameterFields()
Dim paramField As New ParameterField()
Dim discreteVal As New ParameterDiscreteValue()
Dim rangeVal As New ParameterRangeValue()