Merging Two Tables in Report

Question

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 SoftwareCourse Ware - 4 Rows Now i want to merge this two tables and Need to display the Unique data in Crystal report.

Jignesh Trivedi · Answer

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