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.
