Experience in using Crystal Reports 3-displaying fields in multiple tables in a report (using Table Association)

A simple example:
Employee table (employee ID employee name department ID)
Department table (Department ID Department name)

Required: Select employee table. employee name, Department table. Department name from employee table, Department table where employee table. Department No. = Department table. Department No.

Operation steps (to list several important ones, which are also difficult to operate at the time)
1. Drag the XSD file directly into the employee table and department table without any field Association.
2. Create the rpt file, select the employee table and department table, and create the Department number that links to the employee table ---> Department Number of the Department table
3. Drag the. aspx file into the report Control
4. Create a dataset in. aspx. CS, which contains two tables named "Employee table" and "department table" (consistent with the name of the XSD to be dragged)
The SQL statements are:
Select * from employee table
Select * from department table

This is basically the case. You can try to discuss any issues.