Crystal Formula

[computerman29651]

I need a crystal formula to calculate the next invoice number.

As of right now, I have the following formula:

PageNumber + {?Invoice Number} -1

What I need if a Sample ID (1234) continues for three pages with an Invoice Number 2560, I need the next Sample ID to have a Invoice Number 2561.

Right now the next Invoice Number is going to 2563.

I am using Crystal 10.

 

[hilfy]

Try using a variable, something like this:

numbervar InvoiceNo;
if previousIsNull(table.groupfield) then
  InvoiceNo := {?Invoice Number};
else if ({table.groupfield} <> previous({table.groupfield})) then
  InvoiceNo := InvoiceNo + 1;
InvoiceNo;

"{table.groupfield}" is whatever field you're using to group by that determines what an invoice is. This should set the invoice number to your parameter value when you start processing and then increment it by one every time the group changes. You may have to add "WhilePrintingRecords;" or "WhileReadingRecords;" at the top of this formula to get it to work right (I haven't tested it.)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[computerman29651]

hilfy,

I had to modify the code just a little, but it worked perfectly. Thank you.