Dim myconn As SqlClient.SqlConnection = New SqlClient.SqlConnection("data source=sqlserver;initial catalog=northwind;persist security info=False;user id=sa;password=;packet size=4096")
Dim MyCommand2 As New SqlClient.SqlCommand() Dim MyDA As New SqlClient.SqlDataAdapter()
'----------------------填充customer表------------------------------------
MyCommand2.Connection = myconn
MyCommand2.CommandText = "select * from customers"
MyCommand2.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand2 'Dim myDS As New DataSet1()
Dim myDS As New DataSet() '-----------这里可以不用填充动态的dataset1,但在设计报表时不能没有数据集。"奇怪"!
MyDA.Fill(myDS, "customer") '-----------记住这里的填充的名"customer",必须和报表的表名一样。
crReport.SetDataSource(myDS) '-----------如果设计报表时没有dataset,这里就不可以进行填到报表的dataset,报表将不能接收到数据值
Dim crFormulas As FormulaFieldDefinitions
Dim crFormulaTextField1 As FormulaFieldDefinition
Dim crFormulaTextField2 As FormulaFieldDefinition
Dim crFormulaTextField3 As FormulaFieldDefinition Dim crFormulaDBField1 As FormulaFieldDefinition
Dim crformulaDBField2 As FormulaFieldDefinition Dim crFormulaGroup1 As FormulaFieldDefinition
crFormulas = crReport.DataDefinition.FormulaFields crFormulaTextField1 = crFormulas.Item(0)
crFormulaTextField2 = crFormulas.Item(1)
crFormulaTextField3 = crFormulas.Item(2)
crFormulaDBField1 = crFormulas.Item(3)
crformulaDBField2 = crFormulas.Item(4)
crFormulaGroup1 = crFormulas.Item(5)
crFormulaTextField1.Text = Chr(34) & field1 & Chr(34)
crFormulaTextField2.Text = Chr(34) & field2 & Chr(34)
crFormulaTextField3.Text = Chr(34) & group1 & Chr(34) crFormulaDBField1.Text = "{Customers." & field1 & "}"
crformulaDBField2.Text = "{Customers." & field2 & "}"
crFormulaGroup1.Text = "{Customers." & group1 & "}"
CrystalReportViewer1.ReportSource = crReport
CrystalReportViewer1.DataBind()
Dim MyCommand2 As New SqlClient.SqlCommand() Dim MyDA As New SqlClient.SqlDataAdapter()
'----------------------填充customer表------------------------------------
MyCommand2.Connection = myconn
MyCommand2.CommandText = "select * from customers"
MyCommand2.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand2 'Dim myDS As New DataSet1()
Dim myDS As New DataSet() '-----------这里可以不用填充动态的dataset1,但在设计报表时不能没有数据集。"奇怪"!
MyDA.Fill(myDS, "customer") '-----------记住这里的填充的名"customer",必须和报表的表名一样。
crReport.SetDataSource(myDS) '-----------如果设计报表时没有dataset,这里就不可以进行填到报表的dataset,报表将不能接收到数据值
Dim crFormulas As FormulaFieldDefinitions
Dim crFormulaTextField1 As FormulaFieldDefinition
Dim crFormulaTextField2 As FormulaFieldDefinition
Dim crFormulaTextField3 As FormulaFieldDefinition Dim crFormulaDBField1 As FormulaFieldDefinition
Dim crformulaDBField2 As FormulaFieldDefinition Dim crFormulaGroup1 As FormulaFieldDefinition
crFormulas = crReport.DataDefinition.FormulaFields crFormulaTextField1 = crFormulas.Item(0)
crFormulaTextField2 = crFormulas.Item(1)
crFormulaTextField3 = crFormulas.Item(2)
crFormulaDBField1 = crFormulas.Item(3)
crformulaDBField2 = crFormulas.Item(4)
crFormulaGroup1 = crFormulas.Item(5)
crFormulaTextField1.Text = Chr(34) & field1 & Chr(34)
crFormulaTextField2.Text = Chr(34) & field2 & Chr(34)
crFormulaTextField3.Text = Chr(34) & group1 & Chr(34) crFormulaDBField1.Text = "{Customers." & field1 & "}"
crformulaDBField2.Text = "{Customers." & field2 & "}"
crFormulaGroup1.Text = "{Customers." & group1 & "}"
CrystalReportViewer1.ReportSource = crReport
CrystalReportViewer1.DataBind()
解决方案 »
- document.getElementByID("Hidden").value="true";不管用?
- 用Datagrid时候出的点问题
- 写javascript有什么好的软件吗?
- 下载加密问题?求教
- 求助:怎样获得checkboxlist控件中checkbox的个数?
- 小菜一碟——一步一步用c#写论坛,V1.22源代码发布!
- 在flsh中如何使各图片组成动画播放
- 请问在asp.net的页面中,如何判断gridview中某一列图片路径字段是否为空来显示图片?
- 【在线等待】如何给刷新时间赋值
- 请教一个有关DataGrid不能显示的问题!
- 大家来看一下Response.BinaryWrite()之后Response.End()引出的违例的问题
- 如何得到一服务器控件的所有事件列表?
其中想运行的话请设计报表时,在报表中加6个公式这段
Private Function GetFieldObject(ByVal reportObjectName As String) As FieldObject
Dim field As FieldObject ' 按名称获取 ReportObject,将其转换为 FieldObject,
' 并返回此对象。
If TypeOf (crReport.ReportDefinition.ReportObjects.Item(reportObjectName)) Is FieldObject Then
field = crReport.ReportDefinition.ReportObjects.Item(reportObjectName)
GetFieldObject = field
Else : GetFieldObject = Nothing
End If End Function调用时写
With GetFieldObject("Field7") '----------Field7报表对象的name
.Top = top
.Left = left
End With