Hello everyone,
I have a
question about the possibilities in the detail section:
we have
multiple transports where each transport can have multiple kinds of goods and
we would like to use the detail section to show both of them.
It should
look like this (simplified) e.g.:
Truck A
2 Pal. Lights
1 Pal. Bananas
20 Pal. Apples
Truck B
4 Pal. Cups
2 Pal. Gloves
…..
The problem
is that in SQL we have no other possibility to join the tables so that the
result looks like see att..
This will
transform in multiple lines:
Truck A
2 Pal. Lights
Truck A
1 Pal. Bananas
Truck A
20 Pal. Apples
Truck B
4 Pal. Cups
Truck B
2 Pal. Gloves
I also
tried to use a table or a list Item but both would show all results for each
entry.
Truck A
2 Pal. Lights
1 Pal. Bananas
20 Pal. Apples
4 Pal. Cups
2 Pal. Gloves
Truck B
2 Pal. Lights
1 Pal. Bananas
20 Pal. Apples
4 Pal. Cups
2 Pal. Gloves
Is there
any possibility with another item, format, filter,group ..anything to get one row
for each truck and with the goods for this one?