how reverse row and column in the crosstab

kevin23_hy

i indulge confusing about Title's,who can gives me a example or idea. pls help!

thx in advance.

Find more posts tagged with

Comments

mwilliams

Hi kevin23_hy,

Can you explain more about your problem? Also, what version of BIRT are you using?

kevin23_hy

Hi,michael:)
i have a requirement that row and column can exchanged by click a botton(named exchange) in crosstab report.
eg.

COUNTRY STATE CITY BLOCK
MacDonald
KFC
PizzaHut

MacDonald KFC PizzaHut
COUNTRY
STATE
CITY
BLOCK
Total ****

do you understand,so how can i do that(JavaScript Event?),or what DesignEngine api can implementation as well.

pls give the idea.

mwilliams

kevin23_hy,

I don't believe there is a way to do that in one crosstab. I can offer two different suggestions.

1) You can create 2 different reports, one with one setup and the other one with the other setup. Then you would just have to put a hyperlink-drillthough on each report that would call the other report when clicked.

-OR-

2) You can create the 2 separate crosstabs in 1 report and use a parameter to hide/show whichever version of the crosstab the user wants to see. Then you could have a hyperlink-drillthrough that calls that same report with the other parameter value when the user clicks it to see the other view.

Hope this helps.

kevin23_hy

dear Michael,
your two sugestions is great, i prefer to NO2 for performance but my BOSS
has a requirement more harsher that he wants input dynamic params by CheckBox,the two groups that one is for row and other is for column options and then to get feedback to show from DB(according options' change to turn).
I think can use BIRT API to implementation is more flexible,it has anyone example about that or crosstab API's. (i can not find in google so far)
so where can get the example usedby crosstab API and Somebody to provide it for me i would be appriciated.

look aforward reply ASAP.

sincerely kevin:)

mwilliams

Kevin, 
 
I'm pretty sure there is some example code for building crosstabs with the API in the source code for birt. <a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/450-how-to-build-birt-from-cvs/#description'>This post</a> from the devShare will show you how to access the source code.

kevin23_hy

dear, michael 
BIRT source code was gotten,i just wanna a complete one which to be consisted of each Interfaces and implement classes just as <a href=http://wiki.eclipse.org/Java_-_Dynamic_Report_Servlet_(BIRT)>this post</a>. 
 
However,i find a solution is to implement by oralce10g function.eg.as follows(just a column turns to row direction): 
 
create table SCORE 
( 
id NUMBER(2), 
student_name VARCHAR2(10), 
subject VARCHAR2(10), 
score NUMBER(6,2) 
) 
 
 
 
select id,student_name, 
sum(decode(subject,'Chinese',score)) CHINESE, 
sum(decode(subject,'Math',score)) MATH, 
sum(decode(subject,'English',score)) ENGLISH, 
sum(decode(subject,'Computer',score)) COMPUTER, 
sum(decode(subject,'Art',score)) ART 
from score 
group by id,student_name; 
 
 
but how can be used in Mutible Dimensions(eg. a cubSet of CrossTab), is OLAP? MyBoss hint that before but i have no idea about it. 
I am eager to know any other mathod or solution to resolve. welcome guys to take part in the talk:) 
this is my msn: <a href='mailto:' title='E-mail Link' class='bbc_email'>kevin23_hy@yahoo.com.cn</a> -OR- <a href='mailto:' title='E-mail Link' class='bbc_email'>kevin23_hy@live.cn</a> 
 
sincerely kevin.