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 derfloh 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. JanCampbell

    Sorting Records before a group

    I am using Crystal 8.5 to report from a Pivotal database. I am grouping my report by COMPANY.companyid but want to see the records in alphabetical order of company name, not ascending order of company id. Is this possible? Thanks Janice
  2. JanCampbell

    Using the LIKE operator

    Are there any known restrictions/problems with the LIKE operator? I have a very simple selection formula: {CONTACT.JOBTITLE} like "*director*" which is returning 0 records. I have also tried: {CONTACT.JOBTITLE} like "*" + "director" + "*" which also...
  3. JanCampbell

    Setting Detail values based on a group summary

    Hi I am fairly new to Crystal and not that technical so hope you can help. I have a report grouped by an ID field eg. Group Header: 21189 Detail: Company A Value 1 Company B Value 2 Group Footer: Count({Company}) I want to set the value field for all records in the detail...
  4. JanCampbell

    Adding sub and Grand totals for formula field

    I am new to Crystal and have a very simple problem: I have a formula field calculating commission based on a 'Total Value' field in the report. For example, the formula reads: if product_type = "XXX" then (sale_value*5)/100 else (sale_value*2.5)/100 All I want to do is add a...

Part and Inventory Search

Back
Top