Reports for Multi-enum-field

[Ari]

Hi,
I'm trying to create a grid-report as shown below:

Details	Sum
Detail 1	3
Detail 2	1
Detail 3	6
Detail 4	3
Detail 5	4

I have no idea how to create such a report.

System settings:

Table CLIENTS

1. Field "Home" (Enum-field)

Values:

• Value1
• Value2

1. Field "Details" (Multi-Enum-field)

Values:

• Detail1
• Detail2
• Detail3
• Detail4
• Detail5

Condition1: Home = Value1 then Detail1, Detail3, Detail5
Condition2: Home = Value2 then Detail1, Detail2, Detail4, Detail5

The report should count each value, which one is selected (used) in field "Details" für each client.
Any ideas how to build this report?
Thanks.

[item]

Hello,
report with multi-enum don't work as you ask
because in database .. is stored like ['x', 'y', 'z']
i think actually not possiblility ......
Regards

[Ari]

OK, thank you for response.