[RESOLVED] Referencing another row in a table?

[NullEntity]

I'm trying to create a report of our customer's chemical usage. We have an Invoice table with a row that has the part name and then the quantity. One of our quantities we have to subtract from another. So I need the subtotal to be the actual total - one of the other totals. I couldn't figure this out on my own.

Sorry if I sound frustrated!

[jggtz]

Welcome to CodeGuru Forums !

If you can identify the rows then you can use a formula field

[NullEntity]

The issue I'm having is that I'm not sure which row it'll process first.

[NullEntity]

Is there a way to control which order they get processed in? Does sorting affect that?

[NullEntity]

Turns out it did. I tried it earlier, but I must've just had something wrong in one of my formulas.

[jggtz]

Also it would be helpful to know about the reporting specific functions:
BeforeReadingRecords
WhileReadingRecords
WhilePrintingRecords
EvaluateAfter.
You can use these functions to guide Crystal Reports as to when your formula should be evaluated.

Should the formula be evaluated before retrieving the records from the database, while reading the records from the database but before the records have been grouped, sorted and summarized, or while printing the report, when the records are grouped, sorted and summarized?
In general, Crystal Reports sets an appropriate evaluation time for your formula, based on how much information the formula needs