Click here to Skip to main content
12,355,066 members (38,745 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.160621.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2016
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