If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

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

Started by bujji, 02 Mar 2009 09:56:00 AM

Previous topic - Next topic

bujji

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.






bujji

Any Open Ideas..,,

please feel free to share your thoughts


regards
bujji

Gollapudi

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.

bujji

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.

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