My report is as follows:
One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)
The second table is a variance report for data that has been shipped (boolean value of 1) and has a sum at the bottom of the table.
My ultimate goal is to take the sum from table1 where shipped=1 and subtract it from the variance sum from table2.
This will be placed in a textbox at the bottom of the report.
I understand if this sounds confusing but I would be more then happy to provide more information.
© Stack Overflow or respective owner