Crystal report 9 formula issue

Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    What is stored in employee.employee and supervisor.employee ? What is criterion to tell whether the employee is a supervisor or not ?
    69,835 pointsBadges:
    report
  • BasicCrystalreports
    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.
    15 pointsBadges:
    report
  • carlosdl
    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.
    69,835 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following