how to display crystal report in crystal reportviewer

Question

0.00/5 (No votes)

See more:

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

Posted 19-Jan-14 18:24pm

Navi Sandhu

Add a Solution

2 solutions

Solution 1

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();

and in the reportviewer pageload

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

Posted 19-Jan-14 18:37pm

sahabiswarup

Updated 19-Jan-14 18:39pm

v2

Comments

Navi Sandhu 20-Jan-14 7:25am

sir i want to access data from 2 tables at a time

sahabiswarup 27-Jan-14 12:53pm

You can create one view in the database, of generate one datatable writting one join sql and use that. Hope this helps.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2014-01-19T20:08:00

Solution 2

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[^]

Posted 19-Jan-14 20:08pm

thatraja

Updated 20-Jan-14 1:56am

v2

Comments

Navi Sandhu 20-Jan-14 7:46am

thanku sir it is very useful fro me

thatraja 20-Jan-14 7:48am

welcome

Navi Sandhu 20-Jan-14 7:48am

I m workoing on sales system and i want to access details from sales table a particular bill no s details bt i access the full table report so hoe can i access a particular bill no s details in crystal report viwer

thatraja 20-Jan-14 7:56am

Check updated answer

Navi Sandhu 20-Jan-14 8:10am

but Sir i m using Access database in VB.net2010

thatraja 20-Jan-14 8:15am

Database doesn't matter. Same thing when you bring tables inside reports

Navi Sandhu 20-Jan-14 8:17am

ok thnk u sir i will try

thatraja 20-Jan-14 8:27am

ok