O'Reilly logo

Integrating Crystal Reports into an ASP.NET Application by Vince Varallo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required