
Visual Studio.NET with Crystal Reports and Joined Tables
I have created a data adapter,connection and dataset in VB Code and
with a JOIN SQL statement have created a table from two other tables
and sent the result to a DataGrid Control on a Windows form. (Works
Fine)
I am now trying to get the same output in a Crystal Report.
In the Design IDE environment:
a) I created a DataSet including the two database tables
b) I then created a Crystal Report .rpt file including the fields I
wanted from the two tables
c) In the VB code I joined the two tables (INNER JOIN) using SQL as in
the data grid example but I do not know how to get the report to pick
up this joined table. (the data source for the report object is a
dataset rather than a table)
The walkthrough from Crystal Reports has a last sentence that
summarizes the technique but the devil seems to be in the details.
In addition, (assuming that I can be successful with the above) how
can I do it programmatically as in the DataGrid example?
Any help is appreciated!
Regards,
Greg