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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Monkey820

    if any are fail then fail

    Works GREAT!!! Thank you soooo Much!
  2. Monkey820

    if any are fail then fail

    I am not able to make it work. I am having a problem with nulls. If it is null it needs to fail. The values are null, 0.00 and 1.00.
  3. Monkey820

    if any are fail then fail

    one field INSPECTION SAMPLE SEQ PASS/FAIL visual inspection 1 pass visual inspection 2 fail dimensional inspection 1 pass dimensional inspection 2 pass
  4. Monkey820

    if any are fail then fail

    Hi, I need a formula placed in my group header that says "Pass" or "Fail" when looking at the details. But, I want it to "Pass" if all attributes in the details = "Pass" and "Fail" if any of the attributes in the details = "Fail". Any help is appreciated. Thanks, CWR 11.0.0.1282
  5. Monkey820

    percentage difference

    Perfect! Thank you! Thank you!!
  6. Monkey820

    percentage difference

    and .... I need to format the value ex: 10%
  7. Monkey820

    percentage difference

    I need to know the percentage {Table.Avgcost} difference from {Table.Stdcost} per itemnumber and if the percentage is over 10% to change the font color to red. This is a detail line item.
  8. Monkey820

    percentage difference

    Hi! I need to show the difference between 2 values in percentage. I have been away from crystal for a while and am feeling lost. Any help appreciated. Thanks
  9. Monkey820

    Value 0 gives percentage error

    Absolutely Perfect! Thank you!
  10. Monkey820

    Value 0 gives percentage error

    If the {table.GOOD_PTS} value is 0, I get a "Division by zero" error. What formula should I use to consider this possiblity? I want to see a percentage but there will be some values of 0 in the report and, of course, I do not need to calculate them. But the other values in the report will need...
  11. Monkey820

    Keyboard Input

    An app with an embedded viewer
  12. Monkey820

    Keyboard Input

    No, it would be in the case the address differs from what we have on our ERP system.
  13. Monkey820

    How do I enter a "return" line in a text string?

    Absolutely perfect! Thank you so much! I love this site!
  14. Monkey820

    How do I enter a "return" line in a text string?

    I am trying to arrange fields in a formula: if {table.FOB} = "COLLECT" then {@shipto} I need the {@shipto} formula to list the {table.ATTN}, {table.ADD1}, {table.ADD2}, etc. in a properly lined order such as: Attn: Company Address1 Address2 City, State Zipcode TIA for any suggestions! Micky...
  15. Monkey820

    Keyboard Input

    Is there any way to add a prompted field for the user to keyboard input their own address information on a report? Any help is appreciated! Thanks, Micky WinXP CRW 8.5
  16. Monkey820

    suppress if the 6th character equals -0-

    Excellent!! Thank you very much!!
  17. Monkey820

    suppress if the 6th character equals -0-

    Ahh! I used left({table.field},1) in ["1","2","3"] and then got a true, false value, so I suppressed the false. Is that an acceptable way to get my result or is it too messy?
  18. Monkey820

    suppress if the 6th character equals -0-

    Will this suppress 1, 2 and 3? I need to see only 1, 2 and 3.
  19. Monkey820

    suppress if the 6th character equals -0-

    OK - Now I need to suppress everything that does not start with 1, 2 or 3 in the first position of a string field. Any help? Micky CRW 8.5 WINXPPRO
  20. Monkey820

    suppress if the 6th character equals -0-

    The 0 is just a 0 , no dashes (sorry) Your information helped! Thanks!

Part and Inventory Search

Back
Top