I have set up a Crystal Report in my VB.NET 2003 application.  I am currently using a dataset to populate the report.  When I query only one table and set the dataset equal to the query results CR reports correctly.  The problem is when I query multiple tables in my SQL query and pass the results to the dataset, CR reports nothing. 

 

What do I need to do to report a dataset that has multiple tables in it?  I did some research and it looked like I needed to use inner joins in my statement, but that didn't work.

 

Any help is appreciated.

 

Thanks

Tim