我正在使用ASP.NET、SQL和Crystal Report。我已经成功生成了单页报告。但是当报告大小超过一页时,Crystal Report只显示第一页的数据。当我点击下一页按钮时,它会显示“源为空或未找到源”的提示信息。
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim rptDoc As New ReportDocument
Dim ds As New StudentDataSet
Dim sqlCon As SqlConnection
Dim dt As New DataTable
dt.TableName = "Crystal Report Example"
sqlCon = New SqlConnection(myCon)
Dim da As New SqlDataAdapter("select * from tblStudent", sqlCon)
da.Fill(dt)
ds.Tables(0).Merge(dt)
rptDoc.Load(Server.MapPath("~\Reports\StudentList.rpt"))
rptDoc.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rptDoc
End Sub