Dear Members i work with jasperreport and ireport
i have the next situation, the only way to explain this is with pics the case is that a customer can buy many motorcycles 1 to 4 and 0..N motorcycles parts in the same buy the sql query is a union of 2 select like (SELECT....)UNION(SELECT....) why in this way?, the reason that the first SELECT is to get all the motorcycles to sell (the minimum is 1) and the second SELECT is for the motorcycles parts (0 to N, thats the problem) ok with the theory, pls see ireport.PNG, thats the ireport editor, both circles (color red,green) are located in the Detail Band, the red are for motorcycles and green for motorcycles parts when i execute the JasperViewer i get this page1.PNG, page2.PNG (practically a white page with the bottom with the data of the all price to pay of the buy) maybe you are asking why the behaviour of the page2.PNG the reason is for the (SELECT....)UNION(SELECT....) it gets a lot of NULL results, but i have for all Detail Band objects the option Blank when null and remove line when blank i dont have some idea how to resolve this, please help, maybe some option in ireport that i unknown is there i cant change my query because the report is very special my object is get page like ideal.PNG (edited by hand of course) thanks so much in advanced http://www.nabble.com/file/p17162997/good.tar.gz good.tar.gz -- View this message in context: http://www.nabble.com/problems-with-NULL-and-BLANK-objects-tp17162997p17162997.html Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions