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.
Re: [RESOLVED] Referencing another row in a table?
Also it would be helpful to know about the reporting specific functions:
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
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...