Click here to Skip to main content
13,054,329 members (118,855 online)

Cannot get Crystal Reports vb.net 2008 to display data.

Andrew Alix asked:

Open original thread
Built a CR using following data taken from a database and loaded into a dataset. Below is the code to construct the dataset and set up the report. I put 2 Datagridviews on the form to display the data. Both grids display data, but the report shows nothing.

    Dim ds As New rptDataSet 'DataSet I created using the IDE
    Dim t as DataTable = ds.TmsSchedule  'Primary DataTable with Source material
    Dim s As DataTable = ds.School       'Second table with Student assignments
    ' Pull the data from the database and put it in the dataset.
    Dim sc = From tms In db.TmsSchedules _
         Join sch In db.Schools On sch.SchoolDate Equals tms.schDate _
         Where tms.schDate >= firstDate And tms.schDate <= lastDate _
         Select tms.schDate, sch.SchoolDate ' etc.
    Dim r As DataRow
    Dim rs As DataRow
    For Each dr In sc
       r = t.NewRow()
       r("schDate") = dr.schDate
           ' etc.
       t.Rows.Add(r)
       rs = s.NewRow()
       rs("SchoolDate") = dr.SchoolDate
           ' etc.
       s.Rows.Add(rs)
    next
    ' All the above works and display in the DataGridViews on the report
    ' Below is exactly the same as in another report, but nothing displays.
    Dim objRpt As New rptSchedule 'Report I built from the above Dataset
    objRpt.SetDataSource(ds)          'Point the report to the dataset
    CrystalReportViewer1.ReportSource = objRpt 'Set reportviewer to the report
    CrystalReportViewer1.Refresh()    'Refresh the report.
 
Tags: DataGridView, CrystalReports, dataset

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100