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 Shaun E 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 nettman

  1. nettman

    Record Selection Formula - ORs and ANDs

    ANDs can't work because the same field (folderno and contactid) is then being checked for two different values. Folderno cannot be null AND equal to {?Pm-DCLS_CULTRPT_MAIN_VW.FOLDERNO} This will never bring any data back if the parameter field has a value, which it does.
  2. nettman

    Record Selection Formula - ORs and ANDs

    LB, That's what I was starting to think. I'll just leave it the way it is (3 subreports) and see if I can come up with a resolution to my blank page problem. Thanks again for taking the time to help.
  3. nettman

    Record Selection Formula - ORs and ANDs

    It got the same result. Thanks for replying, though.
  4. nettman

    Record Selection Formula - ORs and ANDs

    Thanks for the reply!! Putting the ISNULL components first does not solve the problem. The report did bring back some data, but only because the comments that were there to be displayed matched the first criteria (before the first OR). Crystal still removes my parens and places one at the...
  5. nettman

    Record Selection Formula - ORs and ANDs

    I am using CR9 with an Oracle 9i database. I have a sub-report that displays comments from an Oracle view. Below is the code I have in the Record Selection Formula ( {DCLS_REPORT_COMMENTS.TESTGROUPNAME} = {?Pm-DCLS_CULTRPT_MAIN_VW.TESTGROUPNAME} ) or ( {DCLS_REPORT_COMMENTS.FOLDERNO} =...
See more

Part and Inventory Search

Back
Top