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
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...
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}...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.