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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hslow
Could you please tell me the name of file and topic ?
Thanks
buddyp
Could you please tell me the name of file and topic ?
Thanks
buddyp
with different conditions