Export label only to Excel

Due to the fact that Excel ignores the page breaks associated with the tables in my report, my user would like me to add a blank label to put space between the tables in Excel only.

If we can force a page break in Excel or make the tables go on different tabs that would be WAY TOO COOL.

Any suggestions?

Thanks,
Christine

Find more posts tagged with

Comments

mwilliams

Hi Christine,

How are your "tables" separated now? Grouping within a single table? Or are they actuall separate tables? If grouped, you can add an empty label to the group footer and make its visibility dependant upon your output type. If separate tables, you should just be able to put a blank label between the tables and do the same as above with the visibility.

cmrdjr

Thanks for the reply! The visibility option works. It is great that you can make things visible under that option based upon output type.

Thanks again for the reminder of that element.

mwilliams

No problem! Always glad to help!