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 Mike Lewis 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. rickm140

    last sale (or most recent sale) greater than zero

    I have developed a sales tax expiration report to keep track of a customer's tax exempt certificate. I now need to add a column where I show the date of the last invoice/sale greater than zero. The reason for this is because we do have invoices amount where the sale amount = $0.00. Does...
  2. rickm140

    changing Crystal report from calendar year to fiscal year

    Is this a Crystal formula or an SQL formula? If it is a Crystal formula, do the '####' specify the year?
  3. rickm140

    changing Crystal report from calendar year to fiscal year

    I have a sales report that I developed for our sales manager based on the calendar year. However, since we are on a fiscal year and not a calendar year, he would like to have it changed to reflect our fiscal year. I have two questions: #1) How do I export the crystal report with the formulas...
  4. rickm140

    Division by Zero

    Pete: thanks for your suggestion. I tried that and it worked flawlessly. Rick Meyer
  5. rickm140

    Division by Zero

    I have a 2-year sales report (YTD and MTD) that I need some help with. It shows the profit % for the grand totals which appear at the top of the report but it will not show the profit % for the detail. Every time I try to create a formula I get "Division by Zero" error message. Can someone...

Part and Inventory Search

Back
Top