on 04-09-2009 10:19 PM
I am trying to build a cross tab which will display for conditions x and y all the string values of z in the sumation field. Originating data would be
x values y values z values
1 1 aaaaaaa
1 1 bbbbbbb
1 1 ccccccc
1 2 ddddddd
1 2 eeeeeee
3 1 ggggggg
what i need back is
x values y values z values
1 1 aaaaaaa, bbbbbbb, ccccccc
1 2 ddddddd, eeeeeee
3 1 ggggggg
I've tried a number of formula ideas but I can not seem to get the z values to show up as desired. Any thoughts or suggestion would be appreciated.
Don
This was resolved by using a sub-report containing a 3x3 matrix of string objects. The string objects were assigned string variables which were built while reading recods. The matrix was put in the report footer of the subreport.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Given that x and y are strings, you need to concatenate the strings.You need to create a formula by going to Field Explorer->Formula Fields->(Right Click)->Create new... and write a code in the following fashion:
x&" "&y
(Note: " " is to keep space between values)
Given that x and y are integers(numeric fields), you need to concatenate the strings.You need to create a formula by going to Field Explorer->Formula Fields->(Right Click)->Create new... and write a code in the following fashion:
totext(x)&" "&totext(y)
Drag this field in the Rows section of the Cross Tab Expert->Cross Tab(panel).
Drag the y field in the Columns section of the Cross Tab Expert->Cross Tab(panel).
See the output.This should work.
Thanks,
Amogh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.