Visual Studio.NET with Crystal Reports and Joined Tables 
Author Message
 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



Tue, 17 May 2005 09:36:59 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Linking Crystal Report with a stored Procedure -- crystal report for visual studio.net

2. i am using vb.net and crystal reports for visual studio.net

3. Visual Studio .NET 2003 and Crystal Report Deploy

4. problem with crystal reports in visual studio.NET

5. problem with crystal reports in visual studio.NET

6. Exporting crystal reports from visual studio.net is not working in the final release

7. Opening or Creating a Crystal Report in Visual Studio.NET

8. Exporting Doc in Crystal Report for Visual Studio .NET as landscape

9. problem with crystal reports in visual studio.NET

10. Visual Studio 6 and Visual Studio .NET

11. Visual Studio 6.0, Visual Studio.Net Difference

12. Visual Studio 6 and Visual Studio .net

 

 
Powered by phpBB® Forum Software