PDA

Click to See Complete Forum and Search --> : [RESOLVED] Need data from two tables displayed


jre1229
Jan 22nd, 2007, 07:58 AM
Hi,
I built a report that currently pulls from one table and uses the following code to populate it.
Dim cr As New ReportDocument
cr.Load(strAppPath & "\Reports\SchDaysPerDept.rpt")
cr.SetDataSource(ds.Tables("tblVacationTaken"))

CrystalReportViewer1.ReportSource = cr

How can I populate this if the data is from two tables?
Thanks

shakti5385
Jan 22nd, 2007, 09:10 AM
Read the crystal report tutoruial at my signature.
There is need proper linking in the two table for showing data.

jre1229
Jan 22nd, 2007, 09:49 AM
shakti,
I clicked on the crystal report tutorial in your sig and read through it. All this does it tell you how to use parameters. I am trying to use two different tables.

jre1229
Jan 22nd, 2007, 09:53 AM
I found it. It was under "CR in VB.NET" in your sig.
Thanks

shakti5385
Jan 23rd, 2007, 05:40 AM
I found it. It was under "CR in VB.NET" in your sig.
Thanks
your welcome
but before posting the question show that in which language you are using the CR