Finally after a year I was able to make a report that is based on 1 table. This works. Before I explain my problem let me first tell you how I got my 1 table report to work.
I am using VB 2008 with an ACCESS 2007 database.
I made a form on wich I planted a crystal report viewer.
Then I created a new crytal report using the wizzard and used the ADO.NET datasets wich I am currently using in my programm.
So I selected a dataset and build the report.
Then..on the form where my crystal report viewer resides I inserted the following code:
This works perfectly...Code:Public Class testreports Private Sub testreports_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'Land_DataSet.tblLAND' table. You can move, or remove it, as needed. Me.tblLANDTableAdapter.Fill(Me.Land_DataSet.tblLAND) Dim rpt As New testCRYSTALREPORT rpt.SetDataSource(Land_DataSet) Me.CrystalReportViewer1.ReportSource = rpt End Sub End Class
But now I want to make a report based on 2 or more tables but then it doenst work.
How do I go about this?




Reply With Quote