Fog Creek Software
Discussion Board

creating a report with assigned to and owned by

I am trying to create a detail report that shows the following information:

1. Case ID
2. Case Title
3. Category
4. Area
5. Assigned To
6. Status
7. Fix For
8. Priority
9. Opened date
10. Opened By

The problem is that the assigned to and opened by fields in the bug table are stored as (id) numbers.  Any ideas how I can get these values resolved as names from the person table.  I think I can do it one at a time but not both at the same time.

I'm using Crystal Reports ver 8.0 but a solution in Access will be appreciated as well.

Friday, January 3, 2003

SELECT sFullName, ixBug from Person, Bug where ixPersonOpenedBy = Person.ixPerson

Michael H. Pryor
Friday, January 3, 2003

Basically just JOIN the Bug table on the Person table.. the ixPerson field in Person is the primary key and the ixPersonOpenedBy (or ixPersonAssignedTo) is the foreign key.

Michael H. Pryor
Friday, January 3, 2003

*  Recent Topics

*  Fog Creek Home