DBCrossTab
Hi,
I have some data from a ADOQuery that contain a value and a contry code.
For example
Value Country
12 NL
25 D
10 D
17 B
35 D
8 A
...
Now I want to display the count of values in a range of 0-10, 11-20, 21-30, ...
The result should be something like
Can I do this in a DBCrossTab Object ?
The rows would be the Country code but in the columns I have to put in something like (Value<11), (Value>10 and Value<21), (Value>20 and Value<31), ......
Is this possible ?
Best regards
TL01
I have some data from a ADOQuery that contain a value and a contry code.
For example
Value Country
12 NL
25 D
10 D
17 B
35 D
8 A
...
Now I want to display the count of values in a range of 0-10, 11-20, 21-30, ...
The result should be something like
        NL  D    B    A
0-10Â Â Â Â 0Â Â Â Â 1Â Â Â Â 0Â Â Â Â 1
11-20Â Â Â Â 1Â Â Â Â 0Â Â Â Â 1Â Â Â Â 0
21-30Â Â Â Â 0Â Â Â Â 1Â Â Â Â 0Â Â Â Â 0
31-40Â Â Â Â 0Â Â Â Â 1Â Â Â Â 0Â Â Â Â 0
Can I do this in a DBCrossTab Object ?
The rows would be the Country code but in the columns I have to put in something like (Value<11), (Value>10 and Value<21), (Value>20 and Value<31), ......
Is this possible ?
Best regards
TL01