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.
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
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
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
[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
[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