Print Page | Close Window

Reporting from Multiple Tables

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4160
Printed Date: 03 Apr 2025 at 8:43am


Topic: Reporting from Multiple Tables
Posted By: bigmac_025
Subject: Reporting from Multiple Tables
Date Posted: 04 Sep 2008 at 10:17pm
Hello,
 
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


Replies:
Posted By: jkwrpc
Date Posted: 18 Sep 2008 at 5:32pm
I will ask the obvious question. Does the multiple table query return records? If the query fails the dataset is empty. The reason I ask is that much to my embarassment I have done this more than once before I realizaed my query was failing
 
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net


Print Page | Close Window