Home > IT Answers > Business Intelligence > Crystal report 9 formula issue
BasicCrystalreports
15 pts.
 Crystal report 9 formula issue
Crystal formula, Crystal Reports, Crystal Reports 9, Crystal Reports formulas, OraOLEDB
I have a crystal report using two Lawson OLEDB queries, with employee.employee and supervisor.employee. Please let me know how can I write a formula which shows the employee which is listed in the report is a supervisor or not. The report does not shows the supervisor.employee field.

Software/Hardware used:
Crystal reports 9 + Lawson oledb
ASKED: November 12, 2010  2:21 PM
UPDATED: November 17, 2010  11:28 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What is stored in employee.employee and supervisor.employee ?
What is criterion to tell whether the employee is a supervisor or not ?

carlosdl
 63,580 pts.
 

if the employee (Unique number) is a manger then it should be there in the Supervisor.employee(Uniques number) filed. We have a report in that some employees are there, we need to find these Employee.employee are there in Supervisor.employee list.

BasicCrystalreports
 15 pts.
 

I’m not familiar with Lawson queries, but if you post your queries’ code we might be able to help.

Also, you said that the report does not show the supervisor.employee field, but is it returned by the query ? If the information is retrieved from the database but is simply not being shown, the solution could be easier.

carlosdl
 63,580 pts.