I am new to Crystal Reports and have no IT background. I am trying to create a report in which I need to use a field twice in the report and don't know how. For my report I have a formula that only shows cases for Officer X:
{CaseID}
{Relationship} = "CEO" AND
{Name} = "Officer X"
This show ever case assigned to Officer X a CEO. This works just fine, now I also want to show the property owners name under the case as well. This is where I am stuck. The property owner would be:
{Relationship} = "Owner" then the {Name} field would show the Owner name.
How can I do this under the same report. Do I do a subreport for the owners, but how would I formulate to only show when the CaseID match?
I hope this makes sense?
IP Logged