Hi, i want to merge two table Fields in Crystal Report. the tables having one common field and the first table contain one row of data and the second table contain four row of data i want the SQL query to display the Unique Data of two tables in report.
Example: Table1 Contain Fields Name,Course Code,Course Name etc.,- 1 Row
Table2 Contain Fields Course Code,Software,Course Ware - 4 Rows
Now i want to merge this two tables and Need to display the Unique data in Crystal report.
Loading
Jignesh TrivediPosted Nov 12, 2013, 7:10 AM
hi,
you can combine this two query in to one query and use report grouping control.
Please refer
http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its