先前負責的報表其合計列皆一併放入 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
熱門文章
-
Ceeport 貼紙 Ceeport sticker 今天剛收到第二次訂購的50張 Ceeport貼紙 , 先在電腦螢幕上貼一張, 在識別證上貼一張, 在皮包裡貼一張, 在Moto手機上貼一張, 然後考慮要不要在Nokia那隻手機也貼一張, 為什麼考慮? 因為好幾天沒用那隻...
-
做了一個可上傳檔案的jsp, 為了能上載不同格式的檔案, 所以用ENCTYPE="multipart/form-data", 結果, 檔案上載成功, 可是卻無法成功取得 内的field值. 在Google搜尋結果中, 看了幾個網站, 發現不少人碰過這樣的問題,...
-
今天的我像垂頭喪氣的公雞, 中午沒留神竟不小心把尚未驗證的程式碼check-in, 結果同仁依例在中午過後重新部署系統, 然後當然馬上就發現了這個500 error! 沒想到要置換回前一版的程式一直無法成功, 這個功能又很多人在用, 最後就把這功能先關閉, 然後主管開會回來就叫另...
沒有留言:
張貼留言