Data is not loading in crystal report from datagridview

Question

0.00/5 (No votes)

See more:

I have 1 datagridview and have created a crystal report too.
I have written a query on some conditions which is displaying in datagridview. so that data i want to display in crystal report for printing

i want to bind the dataset with datagridview and then display in crystal report. but the data from datagridview is not displaying in crystal report.

the code is as follows

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
       Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
       Dim ds As New DataSet
       Dim dt As DataTable
       Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
       Dim da As New SqlDataAdapter(cmd)
       dt = New DataTable
       da.Fill(dt)
       FullsortDataGridView.DataSource = dt

       cn.Close()
   End Sub

   Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click

       Form32.Show()

   End Sub

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Public Class Form32

    Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        Dim crReportDocument As New cr
        Dim ds As New DataSet
        CrystalReportViewer1.ReportSource = crReportDocument
        cr1.SetDataSource(ds.Tables(0))


        Form2.DataDataGridView.DataSource = ds.Tables(0)
       
    End Sub

the last code is for crystal report coding
can anyone help me in getting solution

Posted 30-Sep-13 18:32pm

sudeshna from bangkok

Add a Solution

2 solutions

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)

eternal-hazard · Answer 1 · 2013-09-30T18:36:00

your New Ds Has No Data Inside it !! ( in the Crystal Report Code Part )

add this code

VB

Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
      Dim ds As New DataSet
      Dim dt As DataTable
      Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
      Dim da As New SqlDataAdapter(cmd)
      dt = New DataTable
      da.Fill(dt)
      FullsortDataGridView.DataSource = dt

      cn.Close()

to Actually Load the Data to The Newly Created DS :)

That's Why there is an Error and No Data Appears

eternal-hazard · Answer 2 · 2013-09-30T18:49:00

Solution 2

Yes , to actually get Data for the Report

VB

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Public Class Form32
 
    Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        'Load Data
        Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial     catalog=record;user=sa;password=gariahat")
      Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
      Dim da As New SqlDataAdapter(cmd)
      dt = New DataTable
      da.Fill(dt)
      cn.Close()


        Dim crReportDocument As New cr
        CrystalReportViewer1.ReportSource = crReportDocument
        cr1.SetDataSource(dt)
 

        Form2.DataDataGridView.DataSource = dt
       
    End Sub

Posted 30-Sep-13 18:49pm

eternal-hazard

Comments

sudeshna from bangkok 1-Oct-13 0:58am

when i am running my application and clicking on print button to display the crystal report
the following error is coming
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 1-Oct-13 1:11am

why this error coming?

sudeshna from bangkok 2-Oct-13 23:13pm

Can anyone help me please. not getting the data loaded in crystal report from datagridview

sudeshna from bangkok 2-Oct-13 23:32pm

i think my coding is wrong, because in same project my other crystal reports are working, only this report where i have written this code to extract data from datagridview and print in crystal report, this report not working

sudeshna from bangkok 2-Oct-13 23:33pm

Can anyone help me in rectifying my error

sudeshna from bangkok 3-Oct-13 1:50am

Imports System.Configuration
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportAppServer
Imports System.Data.SqlClient
Imports System.Data

Public Class Form32

Private Sub Form32_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat")
Dim ds As New DataSet
Dim dt As DataTable
Dim cmd As New SqlCommand("select * from fullsort where return_dt is null ", cn)
Dim da As New SqlDataAdapter(cmd)
dt = New DataTable
da.Fill(dt)
'FullsortDataGridView.DataSource = tb2

cn.Close()
' Dim rpdoc As ReportDocument

Dim rpdoc As CrystalDecisions.CrystalReports.Engine.ReportDocument
rpdoc = New stock
Me.CrystalReportViewer1.ReportSource = rpdoc
rpdoc.SetDataSource(dt)

End Sub
End Class

sudeshna from bangkok 3-Oct-13 1:52am

This is my code in the crystal report to load data from datagridview to crystal report.
But the data is not getting loaded in crystal report.the above error is showing. i have added a blank crystal report. created a new dataset and under that new datatable.but the data still not loading in crystal report.