I have the following dataset:
organisation client pos desc total
a 1 1 a 10
a 1 2 b 11
a 1 3 c 12
a 2 1 d 20
a 2 2 e 21
a 2 3 f 22
a 3 1 g 30
a 3 2 h 31
a 3 3 i 32
b 1 1 j 40
b 1 2 k 41
b 1 3 l 42
An organisation can contain one client, but a second organisation has several clients.
The report is generated at the organisation level.
I need on this organisation report per client a table. See attached file for more information.
How do I create this table? Do i need a normal table with grouping? a cross table? or perhaps a sub-report?
I prefer to generate it completely in the designer, if possible!
thanks in advance!
organisation client pos desc total
a 1 1 a 10
a 1 2 b 11
a 1 3 c 12
a 2 1 d 20
a 2 2 e 21
a 2 3 f 22
a 3 1 g 30
a 3 2 h 31
a 3 3 i 32
b 1 1 j 40
b 1 2 k 41
b 1 3 l 42
An organisation can contain one client, but a second organisation has several clients.
The report is generated at the organisation level.
I need on this organisation report per client a table. See attached file for more information.
How do I create this table? Do i need a normal table with grouping? a cross table? or perhaps a sub-report?
I prefer to generate it completely in the designer, if possible!
thanks in advance!