How to pass DataGridView Data to Crystal Report

Question

0.00/5 (No votes)

See more:

, +

I have a DataGridView where some selected data is displaying depending on select query with conditions.

Now i want that DataGridView to print in Crystal Report, which is there in another form.

How do i do that?

The code for DataGridView is as follows.

VB

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")

Dim ds As New DataSet
Dim tb2 As DataTable
Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)

Dim da As New SqlDataAdapter(cmd)
tb2 = New DataTable
da.Fill(tb2)

FullsortDataGridView.DataSource = tb2

Posted 29-Sep-13 21:32pm

sudeshna from bangkok

Updated 30-Sep-13 2:20am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

Comments

sudeshna from bangkok 30-Sep-13 4:59am

this is the code i wrote in crystal report for loading datagridview data to crystal report but its showing error. what is wrong in it?

aboubkr90 30-Sep-13 5:55am

I can't see the rest of it but...
- Check 'cr1' and 'stock1'
- ReportSource is supposed to be 'ds' that you just loaded. Right?

sudeshna from bangkok 30-Sep-13 6:03am

this error i am getting
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

sudeshna from bangkok 30-Sep-13 6:03am

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim ds As New DataSet
Dim dt As DataTable
dt = New DataTable()

ds.Tables.Add(dt)
cr1.SetDataSource(ds)
CrystalReportViewer1.ReportSource = cr1

sudeshna from bangkok 30-Sep-13 6:04am

cr1 is the name of my crystalreport

aboubkr90 30-Sep-13 8:15am

Check the path to see if the dll exists?

1 solution

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 · Answer 1 · 2013-10-19T06:08:00

sudeshna from bangkok wrote:
this error i am getting
Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

How to fix error Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.[^]
Errors Occurred when load the SAP Crystal Report in runtime[^]