Print Page | Close Window

tricky field question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19594
Printed Date: 28 Apr 2024 at 4:40am


Topic: tricky field question
Posted By: bwsanders
Subject: tricky field question
Date Posted: 30 May 2013 at 4:44am
i have a report that is pretty simple column and row type report consisting of


id, lastname, firstname, emailaddress, supervisorname

the client want to include the supervisor email address as well. only that isn't something that is readily available. i was thinking i could say something like

if({supervisorname}) = {lastname} & ", " & {firstname} then {emailaddress}

this isn't really working

supervisors are included in the list of employees so that is why i was thinking it could be done this way.


any thoughts?


thank you in advance.


Replies:
Posted By: DBlank
Date Posted: 06 Jun 2013 at 4:00am

add the table twice and join it on supervisor link from table_1 to employee id on table_2 then use the emaol address from table_2


Print Page | Close Window