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 blue color records were actually appear below jan 30(as usual) , but we need to diaply it as above
Please help me
Thanks in advance
Bujji.
Any Open Ideas..,,
please feel free to share your thoughts
regards
bujji
You can have 3 Cross tabs with Diff Queries [Just copy paste the query and crosstab twice] and add a filter to retrieve the relevant rows in each and every cross tab...
Thanks,
Venu.
Hello Gollapudi Garu,
Thank you very much andi,
almost same way i planned..... mean while i got your valuable advice
Once Again Thanks
Best Regards
bujji.
But However it has its limitations when selected date from prompt?
(i.e) if it is quarter report or else some monthly it is working fine
but when it is using different dates ex(from jan 22 nd to Mar 7) then it is a wont(actually i didn't planned after that)
anyway
Thanks to all whom ever replied & also tried atleast
Best Regards
bujji