Integrating Crystal Reports into an ASP.NET Application

1.4. Select Expert

When you review this report, you can see that the employee Rob Walters is listed in the Engineering and Tool Design departments. This is because there is a junction table between the employees and their departments. An employee could move departments so there is a record with a start and end date for each department that an employee has been in. If the employee is still in the department, then the EndDate field is null. This report should only show an employee once and display their current department. To accomplish this, you can use the Select Expert dialog. This lets you build filters for the report just like a where clause in a SQL statement. This report should only show employees whose EndDate is null in the HumanResources. ...