Link to home
Start Free TrialLog in
Avatar of buddyp
buddyp

asked on

Retrieve same value with different relationship in Crystal Report...

I want to retrieve same field's value with 2 different kind of relationship.

1)Caller contact name: ("Firstname from Contact Table")

Subcase --> Case --> Contact

subc2case --> Relationship name between subcase and case table.

case_reporter2contact --> Relationship name between case and contact.

2)Person Receiving Service:("Firstname from Contact Table")

Subcase --> Contact

sub2contact_svc --> Relationship name between subcase and contact table.

Here i want to put same field of same table in my report.But actually as i told you it should display different name in  my report.

How do i do that in Crystal report 8.0?

Please let me know step by step as soon as you can.

Thanks for your time in advance.

Thanks,
buddyp
Avatar of hslow
hslow

insert two different formula fields to retrieve the field's value
with different conditions
Avatar of buddyp

ASKER

hslow

How do i wrote condition.Could you please give me syntax from my above fields and relationship name.

Thanks for your time in advance.

I am eagerly waiting for your reply.

Thanks,
buddyp
ASKER CERTIFIED SOLUTION
Avatar of hslow
hslow

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of buddyp

ASKER

hslow
Could you please tell me the name of file and topic ?

Thanks
buddyp