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!

  • Congratulations wOOdy-Soft 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 danielw

  1. danielw

    Record Selection

    Thanks dgillz worked like a charm. Dan
  2. danielw

    Record Selection

    I have a report with and operator field. The operator field is a string field with name of the operator in it. When I refresh data it prompts for operator name or * for all operators. If there is no operator name in the record it doesn't show the record even when I use the *. How can I get it to...
  3. danielw

    Formula Help

    Thanks dgillz that was what I needed. Daniel
  4. danielw

    Formula Help

    I have the following formula in my report. if ({Weights.Account} = ["ges2","fr2"]) then {@charge4} else 6 I want the formula to work if I have any weight.account with a 2 at the end of account name Ie ges2,fr2,jj2. Now I have to put each account in between brackets like...
  5. danielw

    Total fields in each record

    Thanks Howard. That was easy. I was trying to make the same formula but it had to = a field. Thanks again. Daniel
  6. danielw

    Total fields in each record

    I have a database with fields of weight.steer, weight drive and weight.tandem I would like to be able to total these three fields in each record and display in a new field called total weight. Thanks, Dan
  7. danielw

    Select certain records

    Using Crystal Reports 8.5. Have database with and account & weight fields. Have parameter & formula to select certain accounts but need to only show records when weight is above 1000. If any one can help with parameters & formula to only show records with weights above 1000 for selected account...
  8. danielw

    search for date help

    I would like to be able to enter the date to search for records for that day. I tried {mydatefield}={?mydateparm}. When prompted for date I enter 7-01-02 or any date in that format & it returns no records when there is records it should show. I used string value in parameter edit. I can set a...
  9. danielw

    search for date help

    Using crstal version 8.5. Have date field in database which lists dates as 7-02-02 for july 2, 2002. How can I search for dates in this field.

Part and Inventory Search

Back
Top