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 IamaSherpa 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. gyro1107

    does CR have a "like" or "in" function like SQL does?

    I have found that you can use the IN statement with Crystal reports. The trick is that you need to enclose the qualifiers in square brackets. I.E. {PO_Custom_TextSmall1.potxt_Small02} IN ['Closed','Active']
  2. gyro1107

    Sum up summaries from a main report w/ summaies of sub report

    I have written a report that uses formulas to select data based on different criteria. I have created summaries in each footer for each formula. The detail is suppressed so only the footer summaries appear. The summaries are then summed by the first group in the report. I have two sub reports...

Part and Inventory Search

Back
Top