davutgurbuz

Hello, Thanks for replying Master, Firstly, Yes I have static content, In fact I produce content from database. One of my friend designed a form design software. The platform is oracle forms 4.5. She is in trouble of reporting by oracle reports 2.5 platform depanding reports restrictions. So I got the design from database as a ResultSet ordered by Y values.I produce JRXML dynamically. This is my subreport runs with EmptyDataSource. Even I use immediate ,stretch or perevent on main report's detail band ,when subreports design exceed main reports design(page height) I got this error.I didnt make things comlicated. They were already comlicated/tools/fckeditor/editor/images/smiley/msn/sad_smile.gif. net.sf.jasperreports.engine.design.JRValidationException: Band height validation for subreport "report" failed in the current page context (height = 630, top margin = 20, bottom margin = 20) : 1. The detail section, the page and column headers and footers and the margins do not fit the page height. I noted the produced report in my previous post on the forum. Now I attach a new main report page setup(height value) smaller than subreport. Even I use Immediate it doesnt work. It throws this exception. Yes I'm new about JasperReports but I couldnt got answer from experts around me, or coulnt find a solution on the net. So I decided to share on the forum. I'm sure there is a solution,,, Secondly , Yes using a second detail band really solved my problem at first ! But I mentioned before, I'm designing report dynamically. So the second detail band closes all the raw. So some objects could be on the middle of two bands. This causes invalid report desing. 1. Warning : Element bottom reaches outside band area : y=589 height=15 band-height=600 In oracle reports when you cover a field by a frame objects pushes each other. I meant stretch works fine.But in Jasper I need to use another band. Jasper Frame cant do that. So in my software desing, 5 CLS :) 10 resultset got first element on the page depending on Y pos 20 when resultset.next value is a Scroolable text area object create new band tag for generated jrxml 30 close new band using <band/> tab. 40 GO 5 OR BREAK :D 50 END //allusion to gwbasic I mean software runs line by line. In this desing things got complicated. Maybe I need to store previous bands and objects Y position and height in an array not to let position an object on the middle of two band. And to store some objects in new detail band. Or I need talk with my friend to change her designer and add a new object band start line and band end line. This is better for me :D I do not see myself an expert but I designed a system, A new Gui and some rules. depending on my new tagging ,software developers may restrict viewer buttons , and restrictions of exporting , exporting format,printing + e-mailing or embeding report to db as a serialized object etc. I attached a screenshot. I extended some classes JButton, JRViewer etc. I built a world for me! But I cant live in this world sadly :( Finally, I thought that users may connect a shared drive(mapped network drive) to run this reporting system. So I imagined I can put Java runtime and jasper libs to this shared folder. And I did it. When I tested my system. I got my first report in 30 seconds. Its long time for users. They havent patience like a software developer. Then I remove groovy lib. Its 1.5MB it effected but not enough and I need groovy. In fact when user run another report it comes faster. Because I dont reconnect db and create Reporting GUI, I just add a tab to my GUI. Thats all. Yes I know connecting db and network status is importent at this point but I need some tips to load jasper libs faster. Beside this jasper has a new plus. Because I need to close current report to run another report in ora-reports. This is my story, This is my challenging study. I cant imagine how things challenging for you. Maybe you have some offers for us to run jasperReports quicker as well. And thanks again for replying this poor developer, Note : In Turkey day and time is :10.17.2010 01:04 :) Best Regards, Post Edited by davutgurbuz at 10/16/2010 21:37

Hi, Seeing Teodor's smiling face good. I Reaaly appriciate JasperReports projects.Beside I'm a loyal fun of JasperReport. Dear Jasper Reports developers, I would likte to share my study, I had a problem on designing subreports that cause exceeding Main report size(B'cause my report's all ojects was staticText). So I solved it from java side. It wasn't easy I cut the exceeding part and created a exceeding_part.jrxml then I compile this part and add JasperViewer object this part and I send page/total page paremeters to the report to see pageNums. Anyway... I have another problem now. I have a textField and data in it overflows. My band's splitType is Stretch and textField isStretchWithOverflow and reportElement isPrintWhenDetailOverflows however IReport and myJavaApp couldnt start report ,just in a loop. When I change page Print Order horizantal amazing it works but objects cant push each other. Interwine,mesh. Text on text. Beside this never split to other page. Am I missing something? All of problems I bump into I love jasperReports in a crazy way /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif After Oracle Reports 2.5 Jasper Reports is a great goal. & Thank you far adding myTurkish resource bundle.I felt as if I'm a part of your project Teodor. Thank you for meeting me with Exciting Jasper Reports. Otherwise I would die with Oracle's report server /tools/fckeditor/editor/images/smiley/msn/wink_smile.gif Best Regards, Code:

You may use CASE(WHEN bla bla) structure but none of them would work. Because when you use it you can just add ORDER BY 'ORDER_FIELD,ORDER_FIELDNO' it means INSTEAD OF ORDER BY 1,2,3 ORDER BY key,value,depart YOU JUST SAY ORDER BY '1','2','3' ORDER BY 'key','value','depart' You need to produce complate sql from criteria first, Its a - but jasper have many + JRSortableDataSource help dynamic sortin maybe I thing not a complate solution.