The moose likes Other Open Source Projects and the fly likes problems with NULL and BLANK objects IReport Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "problems with NULL and BLANK objects IReport" Watch "problems with NULL and BLANK objects IReport" New topic

problems with NULL and BLANK objects IReport

Manuel Jordan
Ranch Hand

Joined: Sep 29, 2006
Posts: 131
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

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

link for a gz file for photos

[ May 10, 2008: Message edited by: Manuel Jordan ]
[ May 10, 2008: Message edited by: Manuel Jordan ]

kill your pride, share your knowledge with all
wood burning stoves
subject: problems with NULL and BLANK objects IReport
Similar Threads
Showing blank page while running the report in Jasper
"Even I" vs. "I also"
Struts 1.1 - for a new project?
Not Desired Presentation for XLS files with Jasper/IReport
Problem in generating Charts with iReport2.0.0