如何在水晶报表查看器中显示水晶报表

问题描述：

Imports System.Data

Imports System.Data.OleDb

Public Class Print

Dim cnn As New OleDbConnection（Provider = Microsoft.Jet.OLEDB.4.0; Data Source = G：\ Billing\bill.mdb）

Dim cmd As New OleDbCommand

Dim dap As New OleDbDataAdapter

Dim ds As New DataSet

Private Sub Print_Load（ByVal sender As System.Object，ByVal e As System.EventArgs）Handles MyBase.Load

End Sub

Private Sub Button1_Click（ByVal sender As System.Object，ByVal e As System.EventArgs ）处理Button1.Click

Dim str2 As String

str2 =SELECT customer。*，item。* FROM customer INNER JOIN item ON customer.billno = item.billno

cmd =新OleDbCommand（str2，cnn）

dap =新OleDbDataAdapter（cmd）

ds =新数据集

dap。填写（ds）

Dim obj As New crv

obj.SetDataSource（ds.Tables（0））

CrystalReportViewer1.ReportSource = obj

结束次级

结束类

Imports System.Data
Imports System.Data.OleDb

Public Class Print
Dim cnn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Billing\bill.mdb")
Dim cmd As New OleDbCommand
Dim dap As New OleDbDataAdapter
Dim ds As New DataSet
Private Sub Print_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str2 As String

str2 = "SELECT customer.*, item.* FROM customer INNER JOIN item ON customer.billno =item.billno"
cmd = New OleDbCommand(str2, cnn)

dap = New OleDbDataAdapter(cmd)
ds = New DataSet

dap.Fill(ds)

Dim obj As New crv
obj.SetDataSource(ds.Tables(0))
CrystalReportViewer1.ReportSource = obj

End Sub

End Class

答

检查这个

VB.NET Crystal Reports for Beginners - Crystal报告查看器 [ ^ ]（带截图）

编辑

两种方式

使用群组

使用ASP.NET中的多个表创建Crystal Report [ ^ ]

或

使用子报告

C＃Crystal Reports - 子报告 [ ^ ]

C＃Crystal Reports - 按需子报告 [ ^ ]

Check this
VB.NET Crystal Reports for Beginners - Crystal Reports Viewer[^](With Screenshots)

EDIT
Two ways

Using Groups
Creating Crystal Report with Multiple Tables in ASP.NET[^]
OR
Using Subreports
C# Crystal Reports - sub reports[^]
C# Crystal Reports - on demand sub reports[^]

您可以在visual studio工具箱中找到水晶报告，通过拖放工具箱添加新的水晶报告。在reportviewer中创建crystalreport obj，在页面加载时调用obj。

以及您要从哪个页面调用print函数创建报表查看器的obj并调用它。这是一个例子

You'll find crystal report in visual studio toolbox, Add new crystal report by drag and drop from the toolbox. create crystalreport obj inside that reportviewer, call obj on page load.
and from which page you want to call the print function create obj of the report viewer and call it. Here is an example

Reportviewer obj = new Reportviewer();
obj.dt = tbl;//tbl is a datatable which stores the value which you want to print
obj.Show();

并在reportviewer pageload中

and in the reportviewer pageload

CrystalReport1 crt = new Reports.CrystalReport1();
crt.Database.Tables[0].SetDataSource(dt);
crystalReportViewer1.ReportSource = crt;

如何在水晶报表查看器中显示水晶报表

相关推荐