使用VS.NET2005, CRYSTALREPORT 11
和以前的VS.NET 有不少改变 请各大虾帮忙解决哈~调试总是提示:您请求的报表需要更多信息.--------------------------------------------------------------------------------
report
服务器名:
数据库名:
用户名:
密码:
使用集成安全性
代码
Partial Class SC_vs_PL_and_IN_report
Inherits System.Web.UI.Page Dim ConnectionString As String = "server=localhost;database=test;uid=mscuser;pwd=123456" Sub show_report()
Try
Dim conn As New SqlConnection(ConnectionString)
Dim dap As New SqlDataAdapter("select * from report", conn)
Dim ds As New DataSet()
dap.Fill(ds, "report") Dim cr As New ReportDocument
cr.Load((Server.MapPath("CrystalReport1.rpt")))
cr.SetDatabaseLogon("mscuser", "123456", "localhost", "test")
cr.SetDataSource(ds.Tables("report")) CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.ReportSource = cr
CrystalReportViewer1.DataBind() Catch ex As Exception
MsgBox("动态数据库连接错误")
End Try
End Sub
和以前的VS.NET 有不少改变 请各大虾帮忙解决哈~调试总是提示:您请求的报表需要更多信息.--------------------------------------------------------------------------------
report
服务器名:
数据库名:
用户名:
密码:
使用集成安全性
代码
Partial Class SC_vs_PL_and_IN_report
Inherits System.Web.UI.Page Dim ConnectionString As String = "server=localhost;database=test;uid=mscuser;pwd=123456" Sub show_report()
Try
Dim conn As New SqlConnection(ConnectionString)
Dim dap As New SqlDataAdapter("select * from report", conn)
Dim ds As New DataSet()
dap.Fill(ds, "report") Dim cr As New ReportDocument
cr.Load((Server.MapPath("CrystalReport1.rpt")))
cr.SetDatabaseLogon("mscuser", "123456", "localhost", "test")
cr.SetDataSource(ds.Tables("report")) CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.ReportSource = cr
CrystalReportViewer1.DataBind() Catch ex As Exception
MsgBox("动态数据库连接错误")
End Try
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货