Hello, I want to create this look as a template so I can create a pdf that looks like this:
How can I...
...group products (certain shirts) by their parent category and have all the products with the same parent category displayed under this category?
...create the sum price of each category?
My database has products and each product has a certain parent category as a field.
Thank you for your help ๐
Solved! Go to Solution.
For a typical Order - Order Details, Parent - Child tables
This template
gives you this output.
The trick is -> <<Start:SELECT(item_categories[id],IN([id],SELECT(order_details[item_category],[order_id]=[_THISROW].[order_id])),TRUE)>>
You first have to extract a list of unique categories associated with the given order - order details. Then you can iterate through the list to display those items having each of the categories.
[EDITED]
For grand total, just add at the end
for
For a typical Order - Order Details, Parent - Child tables
This template
gives you this output.
The trick is -> <<Start:SELECT(item_categories[id],IN([id],SELECT(order_details[item_category],[order_id]=[_THISROW].[order_id])),TRUE)>>
You first have to extract a list of unique categories associated with the given order - order details. Then you can iterate through the list to display those items having each of the categories.
[EDITED]
For grand total, just add at the end
for
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |