Multiple-drill through in crosstab

[shishir4u]

Hi,
I am stuck with the following problem in report studio:

Corresponding to a date 'x', i want to show the number of entries that have delay type1 and delay type2 where delay type1 and delay type2 have 5 values from 1..5. Now, report studio allows me to get table 1 :

delay type 1 delay type 2
1 2 3 4 5 1 2 3 4 5
d1

d2

Table 1

date
x y x y x y x y x y
1 1 2 2 3 3 4 4 5 5
d1

d2

Table 2
where x -delay type 1
y - delay type2


but i want to get the table 2 result for better comparison.

Can some one suggest how to solve this problem?

Thanks,
Shishir.

 

[blom0344]

Table 2
where x -delay type 1
y - delay type2

What in heaven's name does this represent?

Ties Blom