Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by anonymouscdn

  1. anonymouscdn

    OR statement Help

    Ngolem... I realized that I had posted in the incorrect form. Also I thought I gave alot more detail this time than in my fisrt post. And Naith did not have the solution to my problem. Thx anyways
  2. anonymouscdn

    OR statement Help

    That one didn't work. Still only showing people that have Previous Termination Date and Code.
  3. anonymouscdn

    OR statement Help

    Running Crystal Reports 8.5 / Oracle DB Having an problem with and OR Statement. It will only display what is before the OR but will not show anything after the OR. Here is the formula: {EC_EMPLOYEE.EMP_GROUP_CODE} startswith "CU" and ( ({EC_EMPLOYEE.PREVIOUS_TERMINATION_DATE} >...
  4. anonymouscdn

    Problem with an OR statement

    Just incase here is how the report should look when displaying both types of termination dates and codes. Prev Prev Term Term Term Term ID Name Address Group date code Date Code --- ------...
  5. anonymouscdn

    Problem with an OR statement

    I am using Crystal Reports 8.5, Oracle DB, ODBC - Oracle8 v3.6, and it was the Crystal Reports SQL Designer. The report is grabbing retirees over the last 5 years. The report was displaying Employee ID, Name, Address, Group, Termination Date, Termination Code, Previous Termination Code and...
  6. anonymouscdn

    Problem with an OR statement

    When I run this code. It is only doing what is ahead of the or statement and never what's after it. If I run the code in SQL Designer it runs correctly. But I don't want to run it in the designer if I don't have to. {EC_EMPLOYEE.EMP_GROUP_CODE} startswith "CU" and (...
See more

Part and Inventory Search

Back
Top