Cross tab, by limiting the number of colums

Cross-tab is the report, when the number of columns are unknown.

But if the columns exceeds the page, the rest of the columns are moved to next page, by default.

Horizontal-table-break command will be helpful here to repeat the number of columns to the next page.
But if we want to control the number of columns that is displayed and if it exceeds the certain number, then the table has to be created in the same page from the columns where it left.

In case there are 6 columns going accross (columns going accross are dynamic...).
the first 5 columns should be displayed in one table and next 1 in another table below the first table

In case of there are 16 columns going across..
1st five columns in first table,
2nd five columns in 2nd table below the first table,
3rd five columns in third table below the 2nd table and
remaining one column in the fourth table below the 3rd table

is it possible ?

Yes it is possible :)

Here it is.


Comments

Anonymous said…
Hi Vetsrini,

Thanks for the article. I am just trying to simulate the same scenario as you have mentioned.
However, after creating the same data and template, i am getting the following error

Caused by: oracle.xdo.parser.v2.XSLException: Line 59, Column 63: XML-22047: (Error) Invalid instantiation of 'xsl:when' in '_8' context.
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

Could you please help me in resolving the above issue?

Regards,
Maverick
Thu Jun 25, 09:25:00 PM 2009
Vetriselvan said…
drop me a mail with more details, with template and xml. i can have a look at it.
Mon Jul 06, 07:59:00 AM 2009
JK said…
Hi Vestrini,

I have an rtf report with a very long crosstab. I implemented your solution which works fantasrically. Thank You.

I just have one problem - each successive row seems to create a table that is just a bit smaller than the previous, so that at the end, it's noticeably smaller. This makes the entire report look a bit 'funnel shpaed' and is a bit distracting.

Is this expected? Is there a way to prevent this? Am I doing something incorrectly?

Thanks for any help you can provide...

JK
Fri Dec 04, 09:01:00 PM 2009
Anonymous said…
buy bactrim online buy bactrim es online without prescription buy bactrim buy bactrim without prescription buy bactrim without a prescription overnight buy bactrim f
[url=http://bactrim.eventbrite.com/]buy bactrim f [/url]
buy bactrim without prescription
side effects of glucophage glucophage xr glucophage and weight loss losing weight with glucophage glucophage kidney pain when to take glucophage glucophage help with pregnancy
[url=http://takeglucophage.eventbrite.com/]taking medroxyprogesterone then glucophage [/url]
alcohol glucophage
proscar symptoms teva proscar proscar news muscle atrophy proscar side effects proscar spermatogenesis buy proscar online proscar for hair loss
[url=http://proscar.eventbrite.com/]proscar false readings [/url]
prostate cancer resistance to proscar
buy levitra online how does levitra work impotence what is better viagra or levitra levitra medicine cheap levitra levitra young people
[url=http://virb.com/yalevi]levitra sale [/url]
levitra lowest price
buy zithromax no prescription zithromax 500 mg tablets generic zithromax order azithromycin online purchase zithromax online zithromax 250 generic zithromax order azithromycin 500mg generic zithromax order online
[url=http://virb.com/bono]gonorrhea antibiotics [/url]
generic zithromax order azithromycin online
-------------------------------------------------------------------
[url=http://fotak.ru/stats.php?r=winrichman.blogspot.com]my blog[/url]
blog my
Thu Feb 18, 02:26:00 AM 2010
Anonymous said…
buy pepcid for dogs
[url=http://www.wikio.com/article/buy-pepcid-online-buy-cheap-pepcid-139713077]buy pepcid ac[/url]
buy pepcid ac
buy levitra online impotence aid free levitra trial how does levitra work levitra cialis impotency genuine levitra no prescription
[url=http://levitra.typepad.com/]impotence solutions [/url]
impotence advice
apcalis key buy-levitra levitra dangers compare cialis levitra viagra q buy levitra online uprima levitra website
[url=http://virb.com/yalevi]levitra lowest price [/url]
free levitra trial
azithromycine zithromax monodose zithromax z pac generic zithromax 500mg zithromax pediatric dosage buy zithromax without prescription buy generic zithromax
[url=http://virb.com/bono]zithromax medication [/url]
azithromycin zithromax
buy lasix online overnight shipping buy lasix 12.5 mg buy lasix online with overnight delivery where to buy lasix in mexico buy lasix no prescription buy lasix online buy lasix
[url=http://www.magentocommerce.com/boards/viewthread/63722/]buy lasix 12.5 mg [/url]
buy generic lasix
-------------------------------------------------------------------
[url=http://fotak.ru/stats.php?r=www.blogger.com]my blog[/url]
blog my
Sat Feb 20, 10:44:00 PM 2010
Anonymous said…
http://markonzo.edu http://aviary.com/artists/Singulair-side http://profiles.friendster.com/premarin#moreabout koopman costumes http://cipro.indieword.com/ http://aviary.com/artists/protonix spokesperson http://blog.bakililar.az/flagyl/ http://aviary.com/artists/Zyprexa http://blog.bakililar.az/valtrex/ http://aviary.com/artists/Singulair-side tseng http://www.netknowledgenow.com/members/furosemide-side-effects.aspx
Wed Feb 24, 07:11:00 PM 2010
Post a Comment

Popular posts from this blog

Repeat Table Header in all pages in BIP

how to repeat the column titles on a table in all pages if the table extends over several pages What you need to is: 1. Select and Highlight the table header row 2. Right click and select table properties 3. On the Row tab properties , specify that the header row should be repeated on every page 4. Save the RTF 5. BIP looks at the properties of the word settings for the table and will repeat the header row on every page the table needs. This works so well in PDF output, but RTF output seeems to have some issue with this header repeat functionality We all can beleive, In future releases this bug won't be there ;)
Read more

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below
Read more

Configure Concurrent Reports to be run

In BI Publisher Standalone, How many concurrent reports can be run ? By default, it is set to 3. in-order to change it to 'N'. following change is required. 1. Go to Admin/Scheduler/quartz-config.properties 2. identify the line org.quartz.threadPool.threadCount=N 3. Change this to N, in order to concurrent no of reports to be run at a time.
Read more