I am using Crystal 8.5 Developer on Winnt 4.0 and creating a report from a Remedy Database.
I have 6 date/time fields:
PersonA.TimeStamp, PersonB.TimeStamp, etc.
These are populated every time the Assigned to Individual field is populated with the corresponding name. For instance, if the Assigned To Individual field is populated with PersonA, then their TimeStamp field is populated.
My problem is that I need to create one report that will provide the information for each person, on all of the Remedy tickets where their timestamp field is not null (or in a specific date range). There are situations where one ticket will be on more than one person's report because it was assigned to them at one time and they assigned it to the next person.
I think I need to create a variable for the Assigned To Individual names and another variable for each of the 6 timestamp fields.
Any help is greatly appreciated.
Marianne Crane
mjcrane@co.riverside.ca.us
I have 6 date/time fields:
PersonA.TimeStamp, PersonB.TimeStamp, etc.
These are populated every time the Assigned to Individual field is populated with the corresponding name. For instance, if the Assigned To Individual field is populated with PersonA, then their TimeStamp field is populated.
My problem is that I need to create one report that will provide the information for each person, on all of the Remedy tickets where their timestamp field is not null (or in a specific date range). There are situations where one ticket will be on more than one person's report because it was assigned to them at one time and they assigned it to the next person.
I think I need to create a variable for the Assigned To Individual names and another variable for each of the 6 timestamp fields.
Any help is greatly appreciated.
Marianne Crane
mjcrane@co.riverside.ca.us