<p>Hi,</p>
<p>I have created a BIRT report with multiple data tables in different formats: one format to show in html and export to pdf and 2 different formats to export to Excel and not to show in html.</p>
<p>
Because I have 2 different Excel tables I want to export content to Excel and check the box for 'Output to multiple sheets' so that each table is created in a different tab.</p>
<p> </p>
<p>I am trying to set the Visibility property on each of these 3 tables to 'hide for specific outputs'. It seems that if I specify the 'hide' for xls and xlsx (and I have also included native) and do not specify 'output to multiple sheets' the visibility will work and the table will be hidden but if I specify 'output to multiple sheets' there will be a worksheet with a tab for this table but no data. Since this table has a grouping and can create a page for each group the output to Excel has multiple tabs that have no data.</p>
<p> </p>
<p>I have attached a screenshot that shows the output with Event_Strategy_List3 /4 /5 /6 having no data.</p>
<p> </p>
<p>Can you please steer me in the right direction to set the properties correctly.</p>
<p> </p>
<p>Thanks,</p>
<p>Nancy</p>
