先前負責的報表其合計列皆一併放入 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
對不起. 請原諒我. 謝謝你. 我愛你.
I am sorry. Please forgive me. Thank you. I love you.
Lo siento. Perdóname, por favor. Gracias. Te amo.
"When we are willing to take 100% responsibility and let go, what is right and perfect unfolds." 當我們願意為我們所經歷的一切負百分之百的責任時, 適合我們的及完美的一切, 即為我們顯現.--http://www.self-i-dentity-through-hooponopono.com/index.htm
熱門文章
-
今天收到 卡內基訓練 電子報, 讀到一段Dale Carnegie的話, 覺得人生真是如此, 我們的人生真的是自己"想"出來的! 想到自己參加卡內基的訓練後, 想法及內心的改變, 後又再參加一次學長訓練, 當了ㄧ期的學長, 覺得收穫到的似乎比付出的還多! 而且...
-
There are two other Allen that I met so far. One is the little boy next to my house. He is as old as my son. My son likes to play with hi...
-
賽爾號
沒有留言:
張貼留言