Report table linking problem
Hi,
I've created some crystal reports from the SD+ (5507) database previously but now I want one showing workstation specs and department and location. I have so far been unable to get the links and the table relations that I've found have not helped.
I want to show details from "systeminfo" such as make/model, proc.speed, etc. and group it by department.
Most workstations are assigned to a individual user but some are shared machines assigned to a department. I need to be able to resolve each workstation's owner to the user's department or owning department. If it need to collate 2 reports (one for workstations with users as owners and one for departments as owners) for the time being that would be fine but I'm just struggling to get that link.
If someone could lend me a hand I would be very greatful!!!
I've created some crystal reports from the SD+ (5507) database previously but now I want one showing workstation specs and department and location. I have so far been unable to get the links and the table relations that I've found have not helped.
I want to show details from "systeminfo" such as make/model, proc.speed, etc. and group it by department.
Most workstations are assigned to a individual user but some are shared machines assigned to a department. I need to be able to resolve each workstation's owner to the user's department or owning department. If it need to collate 2 reports (one for workstations with users as owners and one for departments as owners) for the time being that would be fine but I'm just struggling to get that link.
If someone could lend me a hand I would be very greatful!!!