Wednesday, March 21, 2012

Dynamic merging cells in Matrix

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

1 1 1

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

1

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