Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

problems with NULL and BLANK objects IReport  RSS feed

Manuel Jordan
Ranch Hand
Posts: 131
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!