Export to Excel excluding blank tabs

building reports webintelligence
1

Hi,
I am using Webi R3 Rich client. I have about 50 tabs in the report and for every run, some might have data, some might not. Is there any option to have the report saved/scheduled as Excel having only the tabs with data? Is it possible to exclude blank tabs? Please help.

Thanks.

teejee (BOB member since 2012-03-18)

2

I’m 99.99% sure the answer is “No”. You might want to consider re-engineering your reports, for example, using Sections instead of Tabs. This gives you a bit more control over whether to show sections or not by exploiting the visibility / hide options. If you absolutely must have separate tabs, they’re all going to export, regardless of the whether they show data.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

3

Thanks mcnelson. For hard-to-convince users separate tabs was a requirement :slight_smile: :cuss: :cuss:

Also, sectioning the only easiest way to make any changes consistently to all of them too… But again :frowning:

teejee (BOB member since 2012-03-18)