I have a matrix like this,
October
W1
W2
W3
W4
W5
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
michelle
Jack
cindy
Nina
Lucia
I need it to be like this:
October
W1
W2
W3
W4
W5
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
michelle
Jack
cindy
Nina
Lucia
The problem is: how to group (merge) those 3 cells. Because this a matrix, the columns are generated by a dataset, so this should be related to something like "dynamic merging cells". I think this not about adding a row group or column group. You can see I have used row groups in the week row and month row.
I wonder if somebody has any idea how to support this. If not, is there any other alternatives, as long as they can produce this result.
I am using SQL Server Reporting Services 2000 SP2
Thank you VERY MUCH!
Nobody has any idea? Or I didn't put something clear?
I need helps.
No comments:
Post a Comment