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 John Tel 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 rgoldman

  1. rgoldman

    Can I do a subselect

    sorry, that is the minimum date in a order date field, I want one date field to be less than the earliest date in another field
  2. rgoldman

    Can I do a subselect

    This is the formula, it produces the results true or false, I then want to select only the true results. When I go to the select tool the formula is not one of my options to select, I imagine it is because the results are the result of a formula and crystal doesn't know what to select on because...
  3. rgoldman

    Can I do a subselect

    I guess you should know I am using 8.5 and I have a evaluation copy of 11
  4. rgoldman

    Can I do a subselect

    I have a formula "IF {RX_TRANSACTION_DETAIL.DATE_FILLED} < {@MIN SUBMIT DATE} THEN TRUE" - I then want to group on the TRUE, or run a query against the TRUE but it doesn't show up as a field to group upon. Is there a way to evaluate this to use in a subselect?
See more

Part and Inventory Search

Back
Top