Saturday, February 25, 2012

Need help, crosstab?

Dear all,

I am a newbie and I have a problem to generate a crystal report...

suppose the data is:

Process style A Style B Style C Style D
1 50 40 100 10
2 100 200 40 20
3 40 70 40 30
4 60 80 40
5 90 150 50
6 150
7 150 170
8 75
(each max number of process is A=8, B=5, C=7, D=5)

Can i display it in one report with the following format?

PROCESS
-------------------
1 2 3 4 5 6 7 8
--------------------
Style A 50 100 40 60 90 0 150 75

PROCESS
----------------
1 2 3 4 5
----------------
Style B 40 200 70 80 150
Style D 10 20 30 40 50

------------------
1 2 3 4 5 6 7
------------------
Style C 100 40 40 0 0 150 170

I tried with the crosstab and the result is:
PROCESS
-------------------
1 2 3 4 5 6 7 8
--------------------
Style A 50 100 40 60 90 0 150 75
Style B 40 200 70 80 150 0 0 0
Style C 100 40 40 0 0 150 170 0
Style D 10 20 30 40 50 0 0 0

Seems like the crosstab presented the max number of all the process (in this case 'Style A' and put zero (or blank if suppressed) for the other styles, although there are no data with process number 6,7,8 for style B and D, and process number 8 for style C

can anyone help me please, i'm stuck..

thanks in advanceso sorry, the previous post did not display the data correctly

the data is:

Process Style A
1.50
2.100
3.40
4.60
5.90
6.-
7.150
8.75

Process Style B
1.40
2.200
3.70
4.80
5.150

Process Style C
1.100
2.40
3.40
4.-
5.-
6.150
7.170

Process Style D
1.10
2.20
3.30
4.40
5.50

thanks

No comments:

Post a Comment