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.

Walter
Friday, January 03, 2003

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

Michael H. Pryor
Friday, January 03, 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 03, 2003

*  Recent Topics

*  Fog Creek Home