先前負責的報表其合計列皆一併放入 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
熱門文章
-
今天發現報表有一個問題, 就是在產生Excel報表時, 欄位名稱那一列會像換頁一樣, 隔幾10列就出現一次, 我設了"print when"也沒效, 猜想可能是這張報表, 我用子母報表的方式完成, 因此, "print when" $V{P...
-
I thank the lesson that the plants taught me this morning. There are new shoots in the dried branch that I was planning to remove. To my s...
-
與您分享此文~ 覺得作者文中所提內心的思維與矛盾的情結, 似乎也常發生在自己身上, 心裡也常會擔心自己/教育會否卻窄化了小孩原本寬廣天真的世界, 教育真是一切的答案嗎? 常常卻覺得, 是小孩重新教育我看這個世界的角度. ==============================...
沒有留言:
張貼留言