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 strongm 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. dmreporter

    Crystal Reports v11 - How do I perform a DistinctCount & Sum

    I need to sum our sales in a 'Net Sales' column but first, I need to perform a disinct function prior to doing a sum function (since there are repeated sales amounts that are not needed)....what's the correct syntax and formula used to perform these functions? Thanks!
  2. dmreporter

    Displaly two different field values into one field - Cryst. Rep v8.5

    Thanks very much for all the feedback. To answer some of your questions, I'm trying to get both Company sales and Franchise sales to display but not sum or concatinate them. Instead, when it's Company sales, it should display in the Net Sales field and when it's Franchise sales, it should...
  3. dmreporter

    Displaly two different field values into one field - Cryst. Rep v8.5

    Using Crystal Reports v8.5, I have two different field values that need to be displayed under one Net Sales column/field. Specifically, I have one field that contains company sales (e.g.: tbl1.compsalesfield)and another field that contains franchise sales (e.g.: tbl2.frsalesfield). If I...
  4. dmreporter

    Changing the Week's First Day to Begin on Tuesday

    I'm new to CR v8.5 and don't know the syntax very well. I'm specifically trying to retreive business dates that begin on Tuesdays and end on Mondays. Therefore, if I want to capture weekly sales totals whereby the first day of the week begins on Tuesdays, what syntax/formula do I use? Any...

Part and Inventory Search

Back
Top