Ho'oponopono Cleaning Tool

熱門文章

2009年6月25日 星期四

⊕iReport 的 "Floating Column Footer" 可以做什麼?

先前負責的報表其合計列皆一併放入 Java Bean List 內 顯示,
可正常產生 Excel 及 PDF 格式報表.
I put query results to Java Bean List to display them
in iReport. Those reports could be generated in Excel and PDF format correctly.

後因合計之金額 依客戶需求公式更改, 並改以共用模組方式取得,
故於報表新增一列 "合計列"於 iReport 之 Summary 區塊.
Due to customer's changes in the formula of their Sum up amounts,
we then retrieved the amounts from a CUM(commonly used module).
Facing the changes, I decided to create a Sum up row in the Summary area of iReport.

如此變動後產生的報表, 於 Excel 格式仍如常顯示, 但於 PDF格式時,
卻多了一塊空白區域於 Detail 區塊 及 Summary 區塊之間.
After the changes, Excel formated reports could
still be generated as usual. However, a surplus space area got
generated while I was trying to create PDF reports.

不管將此"合計列"置於 iReport 中何區塊, 總是如此現象.
No matter which band in iReport I put this "Sum up" row,
the situation remained.

後想到此"合計列"屬 Column Footer, 移至 Column Footer 區塊應屬正確.
Then I thought, this "Sum up" belonged to Column Footer band.
Therefore, I moved it to that area, and I had confidence that I was right.

所以要做的事, 就是移除 Column Footer 及 Detail 區塊之間的空白,
此應屬 報表屬性 之設定, 故至 報表屬性 中尋找解法,
終於在最後一個Tab內的 "Floating Column Footer" 找到了!
The next thing would be to remove the surplus space between
"Detail" and "Column Footer" bands. I got the instinct that
I should check "Report Properties", and I did get the solution in the
last tab called "Floating Column Footer"!!!

將此選項打勾, iReport 就會處理不需要的空白區域,
並將"合計列"貼齊 Detail 區塊 顯示.
Checked this item(Floating Column Footer) and iReport would
take care of the surplus space.
It also aligned the "Detail" and the "Column Footer" band for me!

大功告成, 太開心啦!
I was so appreciated that this resolved the surplus space issue.
Thank you, Divine. I love you.

P.S. the version of iReport is: iReport 3.0.0

沒有留言:

Ho'oponopono Cleaning Tool Locations of visitors to this page