Hmmm... This would actually be a good question for the book's financial reporting chapter.

I think that you're going to have to create a formula for each bucket and the bucket only has a value if the date falls within that range. For each bucket, I would use the DateDiff() function (see page 257-258) to determine the number of days out and return the Amount value if it matches the date range. Let us know how that works out (or post the your formula here if it doesn't give you what you need).

One other option uses just a single formula for the main logic, but requires writing more formulas that just return a variable for each bucket: Create a single formula that has a Global variable for each bucket. Then use the DateDiff() function with a Select Case statement  (see page 293) to assign the value to the proper Global variable. Then you can create a formula for each Global variable that just returns that variable's value. This keeps all your logic in the first formula and makes it easier to read.

Either formula should work fine.

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

The formula is fine, the problem is that the very last line you are concatenating the two values together and returning a string. That's why you can't sum them. You need to create a formula for each bucket and only have it return a single numeric value. I'll copy and paste your formula and make a few changes. This should be two separate formulas.

//@FormulaCurrent:
If datediff("d",{@duedate},CurrentDate) < 30
Then 
    {AROPNFIL_SQL.amt_1}
Else
    0;


//@FormulaOver30
If datediff("d",{@duedate},CurrentDate) >= 30 AND datediff("d",{@duedate},CurrentDate) < 60 Then
  {AROPNFIL_SQL.amt_1}
Else
  0;

Note: You don't need WhileReadingRecords b/c the formula uses a field in the calculation. You only need this when doing calculations that don't involve table data. (see bottom of page 300)


Edited by BrianBischof - 27 Mar 2008 at 2:09pm

Are you saying that you had to put WhilePrintingRecords in the formulas to make them work? That doesn't make sense. Since they use database fields then this shouldn't be necessary. Can you explain in more detail or am I missing something?