Wednesday, February 16, 2011

Crystal Reports in C#.NET - Display Join of Two Tables

One to Many relationship of  Tables ...


1. Add both the tables to DataSet being used.

 
2.Both tables must have Link between them, (e.g Primary Key of 1 Tables as Foreign Key of other)



How to Group the fields ??
-> 1.Right click in Details Section.
2. from the menu Select Report -> "Group Expert".
3. It will open the window "Group Expert" dialog box
4. In that select  those fields, that you want to group together. (as done in above fig.)
5.click on OK.
6. arrange the fields as you want.





1 comment:

  1. Hello Pallavi i create a cr report with one dataset using coding now i need to fetch data from multiple dataset using coding only not joining by mouse click as u shown above can u pls post that with example

    ReplyDelete