topic Re: Prevent Tabs on Multiple Print Requests in ODS and Base Reporting

Prevent Tabs on Multiple Print Requests

OS2Rules — Fri, 27 Nov 2009 16:51:39 GMT

Hi All:

Just a quick question to same me hours and hours of searching...

Is there a way to prevent the EXCELXP tagset from generating a new tab for each PROC REPORT that I have?

I'm generating a number of reports after I open the sheet, but the user wants them one after the other, rather than on separate tabs.

Thanks in advance.

Re: Prevent Tabs on Multiple Print Requests

Cynthia_sas — Fri, 27 Nov 2009 17:23:03 GMT

Hi:
Run your job with the sub-option for doc:
[pre]
ods tagsets.excelxp file='xxxx.xml' options(doc='Help');
[/pre]

and then look for the SHEET_INTERVAL sub-option. I believe that you can control whether a new tab starts by using that sub-option.

In addition, if you want more control over printing of the ExcelXP spreadsheet from within Excel, this is a very useful paper:
http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf

cynthia

Re: Prevent Tabs on Multiple Print Requests

OS2Rules — Mon, 30 Nov 2009 14:09:49 GMT

Cynthia:

Genius, as always.

Thanks.