how to pass the results queried from 2 tables to report

[natpan]

Hi

I am a new user for crystal report and can someone help me solve my problem.

First I query data from one table of my dataset and display on the report. It's fine and can be displayed correctly on report. Below is the code I use to pass the data to crystal reprot.

myDA.Fill(myDS, "resist_run_sample")

rpt.SetDataSource(myDS)

CrystalReportViewer1.ReportSource = rpt


But when I try to query data from 2 tables of my dataset and display on the report, it show the blank report with only titles. I verify that the query statement is correct. So I think the problem is the part where I pass the query results. How can I change the above code so that it says myDS is taking from 2 tables which are resist_run_sample and resist_run threshold.

Hope my question is clear...and thanks in advance

 

[kulrom]

If you don't mind you could take a look at this article/s ... I hope you'll find it helpful http://www.vbcity.com/forums/faq.asp?fid=15&cat=Crystal%20Reports

Kind regards