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 gkittelson 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. SaraJB

    How to display the 3rd Bill Date?

    It works! Thanks for all your help. Sara
  2. SaraJB

    How to display the 3rd Bill Date?

    Thanks for your help, I will try all the suggestions. There's no reason why I've ignored the 4th/5th credit dates, the only reason being that it wasn't required for the report only the first 3 bill dates. Sara
  3. SaraJB

    How to display the 3rd Bill Date?

    Hi I'm using Crystal 8.5 and I need to create a formula to show the 3rd bill date from the accounts table which contains both credit and debit fields. The report needs to display a formula, ThirdPaidBill, which will be the date when the 3rd payment (credit) was made assuming all 3 bills have...
  4. SaraJB

    Date parameter over date range with running totals

    Just removed and the problem is the same.
  5. SaraJB

    Date parameter over date range with running totals

    Hi I've been playing around with different things so don't think they should be there, error on my part. Would this be part of the problem? Sara
  6. SaraJB

    Date parameter over date range with running totals

    Hi I'm using crystal 8.5 and have created 3 running totals all using formulas to evaluate; #cases opened in mth = {@Received date}in{?FromReceivedDate}to{?ToReceivedDate} #open and closed={@Received date}in{?FromReceivedDate}to{?ToReceivedDate} and {CM_COMPLETED_CASE.COMPLETIONDATE}...
  7. SaraJB

    Value from report run on 1 day needs to be used next day....

    I've created a report with a subreports looking at debit/credit transactions in a date range parameter and before the minimum date. The report is to be run on a daily basis and consists of Opening balance = sum{debit}+{credit} <{@min} Debit = sum{debit} in {@min} to {@max} Credit =...

Part and Inventory Search

Back
Top