BIRT交叉報表動態(tài)列DEMO說明

1、該DEMO的環(huán)境是tomcat5.0下，BIRT用的是2.6.2，數(shù)據(jù)庫用的是mysql5.0,該DEMO訪問的地址是 HYPERLINK http:/localhost:8080/portal/birtView?_report=TestReport1.rptdesign&displayFields=account http:/localhost:8080/portal/birtView?_report=TestReport1.rptdesign&displayFields=account,cost_Center,Application_Domain,big_Kind,special參數(shù)_re

2、port是指定報表名字displayFields要顯示的字段，用逗號隔開,如果不寫該參數(shù)，顯示所有字段。其中的對應(yīng)關(guān)系：account賬簿cost_Center成本中心Application_Domain應(yīng)用領(lǐng)域big_Kind-大類special專業(yè)關(guān)于BIRT交叉報表動態(tài)刪除列的說明1、報表設(shè)計部分?jǐn)?shù)據(jù)源,修改自己的數(shù)據(jù)源數(shù)據(jù)集日折一1M值1fi一且囲原劇sf累數(shù)據(jù)集的數(shù)據(jù)結(jié)構(gòu)應(yīng)該是這樣：成本中心應(yīng)用馳域?qū)I(yè)類型CUCSD_FA_123702運(yùn)營齊南另壺司運(yùn)廳綻護(hù)部網(wǎng)塔用固寶送產(chǎn)信息殺統(tǒng)叵網(wǎng)奇業(yè)CUCSD_FA_123702迄莒棄南分雖可網(wǎng)京建設(shè)部網(wǎng)涪用回走貿(mào)產(chǎn)信息丟絨叵網(wǎng)專業(yè)CUCSD_

3、FA_123702走苣齊南分把司網(wǎng)洛建設(shè)部網(wǎng)洛用固完資言電貉立攤匡網(wǎng)專業(yè)CUCSDFAJ23702營齊南分芒司行政朋奔中心管浬用固寶資產(chǎn)通用設(shè)備匱網(wǎng)奇業(yè)CUCSDFA123702運(yùn)營齊南分雖司移功網(wǎng)絡(luò)乏行網(wǎng)洛用固寶資產(chǎn)儀器攸表直網(wǎng)奇業(yè)具體數(shù)據(jù)可見test_tablel.sql文件2、報表元素要刪除交叉報表的分組列，需要刪除列定義、列綁定、分組數(shù)據(jù)定義以及表頭的內(nèi)容2.1數(shù)據(jù)集賬簿的分組定義ac.cQunL_Grcup/E：roperuqaccaunt_Group/accoon匸c/props工tycprope工匸丫name=contsnt匸&name=dccotzntid=7acc.ounL.

4、c/properLycprope工匸yname=ppverticaLAIignAniddle!5令/propercy|賬簿分組列綁定定義accoiintdiitten3ianFPaccounc_GroupFraccountstring賬簿賬簿的分組數(shù)據(jù)定義如下：stringa.cc.Qimt：/tabular-levels賬簿表頭表格定義cc?luzniiid=l&%/column?-賬簿表頭標(biāo)簽定義piopEitypiopeit衛(wèi)cpiopeitypTQpeitypiopei七工rowropezctynaine=MheightAO.4375in二am亡=foE.匸呂.ije12pt亡=,pb

5、orxierHij?itCoiorp,#COr：OC0ame=borxiEri?itStylep,solidrame=,FbD23e2?fiigitJiidtXFFlpxziajiae=,Fve2?t：icmLAZLn.Hmiddlei/piope11.yelnane=F,aheadZabelF,Ld=,ll7pxapeitynaiu.e=fwutffeightQldtext-propertyname=fcext二賬簿ff匸亡豈匸一口工口口亡工匸衛(wèi)交叉數(shù)據(jù)集com.foreveross.kason.birt.BirtReportHandler類中doReport()方法用于刪除交叉報表列分組字

6、段的。具體請看代碼最終結(jié)果:顯示全部列處：5、川.專業(yè)奩g肯Ill敵IHiiS:TS甘疊司審好甘赴司W(wǎng)=S業(yè)即冋第用ffl左君產(chǎn)ffifUflta0aaDrawta0aaD涎丘齊闖m鬲鄭好喘RittE冋崙陽U住逐戶屈晉業(yè)a0aaD莊用PD左場戶BJ時業(yè)a0中OD卡m抽14馬用茶朋詩聞?wù)矩W(wǎng)網(wǎng)奇址Q0OOD世it齊由甘址H專仝#衛(wèi)如豐壯用值醫(yī)當(dāng)左ffiFUr業(yè)a0*0麗咅業(yè)00OaD運(yùn)耳齊阿號址E3帛中區(qū)號也m直汪卡崗儈悌餐用nn業(yè)a0QGDaQa*GDCUOSD_FA_123T02:IFU-|：.-:-衍a0OaDTM-SfeKGD網(wǎng)會止a0OaD冋箱豹面至乂寥：.門a0aaD亟壽業(yè)uQ0QD00OaD;r-t固網(wǎng)曽=11：00000頓8對fi固網(wǎng)音止00QQD貝濟(jì)兩骨普司廳馥JK努中右=；tl；L1.-:-Bl；I-Ji面網(wǎng)奇11：00QQD冃曙聘固主黃P言址制-種遠(yuǎn)林a0a*GD囂師PK盼：2vit3肉范再昭普業(yè)Q(1000話丘齊侖*扯2云行雉滬印冋曙用麻規(guī)口剛誓業(yè)00QQ0bDii-E-5fi玉工百11根據(jù)參數(shù)顯示其中3列忘用爼城大類低認(rèn):齡斤片藪畫Iftfn對斬B電爭空曲QaDa0090Q0砥超用胃走吳產(chǎn)0Qa00QQQ00QQn00+*:.-.L?1QQD