Maximo Open Forum

 View Only
  • 1.  Need some help with a BIRT report

    Posted 04-20-2021 15:42
    I'm trying to create a BIRT report with a sub-report.  Here is what the output currently looks like:



    The part with the aqua background is the subreport.  That is working correctly.  But look at the subsequent rows. . .where the subreport would be, if there were any rows to display, is leaving a blank space.  I want it to hide that space when there are no rows in the subreport, but I can't get it to work.  Can y'all help?

    This is the report design:




    Notice the Visibility rule I have on the inner table.  This seems to be the basic idea of how IBM did it for WOPRINT's subreports but I'm failing here.  Ideas?
    #Reporting

    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------


  • 2.  RE: Need some help with a BIRT report

    Posted 04-21-2021 08:28
    On the general tab for the child table there should be a checkbox Can shrink, have you checked it?, also try Alignment Top if you haven't

    ------------------------------
    Wes Williams
    Northrop Grumman
    ------------------------------



  • 3.  RE: Need some help with a BIRT report

    Posted 04-21-2021 13:20
    Is worklogid in the table binding? (Binding tab)

    ------------------------------
    Danielle Newhouse
    Projetech Inc.
    ------------------------------



  • 4.  RE: Need some help with a BIRT report

    This message was posted by a user wishing to remain anonymous
    Posted 04-21-2021 13:23
    This post was removed


  • 5.  RE: Need some help with a BIRT report

    Posted 04-21-2021 13:37
    For the inner table, yes it is.

    FWIW: I did get this working by changing the query on the outer/parent table by adding a CASE statement to see if there would (1) or would not (0) be any rows that would be in the results of the inner/child/subreport table; then made a visibility rule to hide the row when that CASE results in a 0.

    I'm sure that's not how it *should* be done, but it seems to be working.  I'm comparing it to the OOTB woprint.rptdesign, trying to figure out how they did it for the many subreports there.

    Back to Wes's previous response -- no, I hadn't done either of those, but woprint.rptdesign doesn't do those either.

    It's been awhile since I had to make a BIRT report; I can see I'm a bit rusty.  But at this point I think I'm just interested in figuring out why woprint.rptdesign's subreports hide properly and, when I mimic what they did there, it isn't working in my report.  What am I missing?

    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------



  • 6.  RE: Need some help with a BIRT report

    Posted 04-21-2021 13:47
    Hi Travis --

    Do you have a height defined for the row in the main table that holds the inner table? I would think if the height is null and the inner table is empty w/ the visibility clause you have defined it would make the row have no height and thus not create a space.

    ------------------------------
    Danielle Newhouse
    Projetech Inc.
    ------------------------------



  • 7.  RE: Need some help with a BIRT report

    Posted 04-21-2021 14:53
    Wow, I thought I had checked for that, but, you're right, there was a defined height.  (It looks like the value gets auto-set if you drag the row border to resize it -- even if doing so doesn't make any changes; I tried to make it smaller, but it was already as small as it could be, but it still re-applied a value to the row height).

    So I removed that AND removed my Visibility rule, and the output had a very minimal space between rows; it's still not completely a 0 height.  So I'll put my Visibility rule back in, but I feel like I shouldn't have to.  Woprint.rptdesign doesn't have Visibility rules to make this happen.

    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------



  • 8.  RE: Need some help with a BIRT report

    Posted 04-22-2021 08:47
    Might be worth clearing out the height if you haven't already, so that it's blank. That's what IBM does with the rows that hold the inner tables.

    ------------------------------
    Danielle Newhouse
    Projetech Inc.
    ------------------------------