how Format Cross tab resuts Top to bottom, then left to right

[asini]

Hello All,

in my report i have a simple cross tab, it sinmply contains 1 Cross Tab Row (some date column) , 1 Cross Tab Column ( quarter name) , measure column is some amount.

now when i run report it has some 90 rows it is displaying in 3 pages,

now the question is how can i set my cross tab to display 30 rows (as usual from top to bottom) in one page , and then 31 to 60 just next to 1 to 30 (i.e, left to right) then 61 to 91 just next to 31 to 60



so my cross tab finally looks like this below

Q1 Q1
Jan 1 2009 1200 Jan 31 2009 3000
Jan 2 2009 1200 Feb 01 2009 4000
Jan 3 2009 1200 Feb 01 2009 4000
Jan 4 2009 1200 Feb 01 2009 4000
- ------------------
- ---------------------
--- ---------------------
- ------
-
-
--
Jan 30 2009 1200


the above JAn 31, feb .... records were actually appear below jan 30(as usual) , but we need to diaply it as above

Please help me


Thanks in advance
Bujji.

 

[asini]

Any Open Ideas..,,

please feel free to share your thoughts


regards
bujji