show/hide row

I would like to know how to hide a table row if an inner table has no data. I have a table with an inner table as a subreport which I have set to be invisible if no data. The problem is that the outer table row shows up as an empty row when exported to excel.

I have not been able to figure out how to sync the outer table row and inner table to both be visible or invisible when no data is in the inner table.

Find more posts tagged with

Comments

huhuan

I have the same question

mwilliams

Can one of you explain more about how your report is set up? Do the subreport values come from a different dataset? How do you relate the inner table to the outer row? etc. Attaching a report design to see the setup could also be useful. Thanks.

mcnamara7

In my case, I have the outer table connected to a master dataset and the inner table connected to the detail dataset. They are related using dataset parameter binding...this all works just fine. The inner table is made invisible by testing the Total.count() < 1.

I did manage to find a solution:
The master dataset (a database view) has a field that counts the detail rows. The outer table row is invisible if that field's value is less than 1.

I was trying to determine the row count of the inner table via script, but had no luck. If there is a better solution, I would be interested in it. Thanks.

mwilliams

mcnamara7,

From what it sounds like, that is probably as good a solution as any. As long as it doesn't slow your reports down a ton.