Thanks. That did the trick. However I had checked the help files and they state that the default on this setting is OFF so I assumed I did not have to specify this and did not have it included in the print statement. Is this flag not defaulted each time used, i.e. the switch remembered and then you have to specifically turn it on or off once it has been set in another app or session?
Thanks again. -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "A. Razzak Memon" <[EMAIL PROTECTED]> > At 03:58 PM 6/5/2008, [EMAIL PROTECTED] wrote: > > >I have the following very simple code : > > > >Print BOItemSales + > >OPTION XLS + > >|FILENAME .vfile + > >|SHOW_CANCEL_DIALOG ON + > >|OPEN ON > > > >This creates an XLS file as expected, but the spread sheet has 63 > >lines of data, > >then a new sheet/tab, 63 lines of data, a new sheet/tab, etc., etc. The > >above > >creates an xls file with 14 sheets(tabs) instead of 1 sheet/tab with all the > >records. > > > >What do I need to change? I want the spread sheet to have all the > >data on one sheet. > > Bob, > > That is the result of printing one sheet (Tab) per page. > > Use the additional ONE_SHEET_PER_PAGE OFF option to achieve your goal. > > Here's how: > > PRINT BOItemSales + > OPTION XLS + > |FILENAME .vfile + > |ONE_SHEET_PER_PAGE OFF + > |SHOW_CANCEL_DIALOG ON + > |OPEN ON > > That's all there is to it! > > For complete details, examples and ready to recycle templates, > refer to R:Docs 7.6. > > Very Best R:egards, > > Razzak. > >
