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 Rhinorhino 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 crystalite

  1. crystalite

    Sum Group with whileprinting records formula

    Thanks for your help LB. I'm new to crystal, where would I create the SQL expresiion?
  2. crystalite

    Sum Group with whileprinting records formula

    Option # is an actual database field. The sequence in the database is by option #. The sequence starts with the first option number, doesn't have to be "1", just the lowest number.
  3. crystalite

    Sum Group with whileprinting records formula

    I am using Crystal 8.5. I want to get a sum in my GH1 using the Cost of the first option in each group (GH2). I have the following formulas: // to count the options in the details whileprintingrecords; numbervar counter; counter:=counter+1; counter // to get the cost of the first option in...
  4. crystalite

    Cross tabs - manual or better formulas?

    Beanbrain and LB thank you for your quick response. Ibass - I used your suggestion and it worked perfectly. You rock!!!!
  5. crystalite

    Cross tabs - manual or better formulas?

    I'm using Crystal 8.5 and SQL. I need to create a report that after selecting an item, will show all jobs related to that item and the time to complete each operation (op). The fields are Job, Operation, description (actually 3 fields make up the description) Here's what I would like...

Part and Inventory Search

Back
Top