先前負責的報表其合計列皆一併放入 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
熱門文章
-
It's such a blessing to hear this song and to watch this video. Thank you so much for this song, Seay. May there be peace and joy all...
-
寶寶問媽媽: 樹公公為什麼這麼高ㄚ? 媽媽: 因為樹公公有喝ㄋㄟ ㄋㄟ ㄚ, 喝ㄋㄟ ㄋㄟ 就會長這麼高了. 媽媽(得意): 所以你要長高就要喝ㄋㄟ ㄋㄟ, 知道嗎? 寶寶: ..., 樹公公為什麼要喝ㄋㄟ ㄋㄟ ? 媽媽: 因為它要長高ㄚ 寶寶: ..., 樹公公為什麼要長高...
沒有留言:
張貼留言