如何在水晶报表查看器中显示水晶报表 [英] how to display crystal report in crystal reportviewer

问题描述

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 < br $>


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;

这篇关于如何在水晶报表查看器中显示水晶报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！