Currently Being ModeratedOct 28, 2012 10:48 PM (in response to foxbot)
Most of this looks possible. The most obvious exception is not showing the separate table for grains when no grains are shown.
A table has a defined number of rows and columns. That number may be changed manually, but I know no way of either adding or removing rows (or columns) through the use of formulas. If you want to use separate tables for each of these, you will need to set up four separate tables, each with the number of columns needed and, assuming there is a possibility that any particular order may include all items in at least one category, each with as many rows as there are items in the category for that table.
If you are willing to forego separate tables on the Invoice, then an outcome similar to what you ask is likely possible.
In your example, you have listed the subtotals for each category in which there has been an order at the top of the page, then have repeated those subtotals in a second line in each separate table. Why?
Currently Being ModeratedOct 29, 2012 10:03 AM (in response to Barry)
Thanks for the reply Barry,
The above example is just a fictional example. In reality the master table would have lots of itemes about 50-70. It would also have internal information that I wouldn't want on the invoice like actual costs and profits.
The Invoice itself would have a table on the first page that would just be a summary of the costs. Then on the subsequent pages would be a detailed breakdown of costs, similar to a cell phone bill. I hope that makes sense. I don't mind manually deleting tables that have no values but I would definitely like items that have zero units to not be listed.