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 TouchToneTommy 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: *

  • Users: SaraJB
  • Content: Threads
  • Order by date
  1. 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...
  2. 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}...
  3. 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