Hiding a row if an inner table contains no rows

robbinma

Hello,

I am struggling to finish a report in BIRT 2.3.2

I have two tables.
Table A shows data from dataset 1.
Table B is inside table A and reads data from dataset 2.

I need to hide the row in Table A if there are no rows in Table B (the inner table)

I have tried creating a count aggregation on Table B and then adding a visibility expression on the data row in table A.
This fails though because the visibility expression in Table A can't see the aggregation value in Table B. That makes sense but it doesn't help me!

I can't merge the data sets or use a joint data set.
I am using BIRT 2.3.2 with Maximo and would appreciate any advice/help about how to achieve this.

Thanks.

Mark

mwilliams

You should be able to check the inner table in the onCreate script and then hide the table row in your onRender script. You'll have to use separate run and render tasks for this to work. If using a URL to run your report, you'll need to use frameset rather than run. Let me know if that doesn't work for you.