Should'nt this report be redesigned? Does the person who asked for this realise how hard it will be to look at the result with infinite rows and infinite columns? Have you challanged the need for this exact layout?
Just your example with 3 transaction types is though enough to read. Seldom can 3 or more dimensions of data be successfully displayed in only 2 dimensions.
So I would redisign it so that you get the result on, lets say, one page per salesman.
|