I am developing a form to print quotes for my company's customers.
One variation of the requirements calls for the line items to be grouped into table sections by category.
The data stream typically comes in as follows:
1. Line Item: Widget1, Category: Tangible Goods
2. Line Item: Widget1 Support, Category: Support
3. Line Item: Widget1 Services, Category: Services
4. Line Item: Widget2, Category: Tangible Goods
5. Line Item: Widget2 Support, Category: Support
6. Line Item: Widget2 Services, Category: Services
For most quotes, line items populate the quote in the order they appear, which is that support and services are grouped with their product.
However, the variation calls for line items to be grouped by their category, so instead the data would appear as follows:
Products
1. Line Item: Widget1, Category: Tangible Goods
4. Line Item: Widget2, Category: Tangible Goods
Support
2. Line Item: Widget1 Support, Category: Support
5. Line Item: Widget2 Support, Category: Support
Services
3. Line Item: Widget1 Services, Category: Services
6. Line Item: Widget2 Services, Category: Services
I know I can create a separate table with sections and hide it until this layout is called for.
I also know that I can evaluate each line item for its category.
What I don't know how to do is to send the line item to its appropriate section based on its category.
Is this possible?
Thanks!
