Any NewViews table (a window with rows and columns) can be printed in its entirety, or you can print a specific block.
Activate any field on the table you wish to print.
Issue the command Print>All.
Activate the table containing the block you want to print.
Use the commands Block>Start and Block>End to mark the block you wish to print.
Issue the command Print>Block.
Edit the print settings and click the Print button.
Use the User Option, Prompt Display Style to switch between modern and classic styles.
If the name of the setting includes the character pattern "automatic titles" (case and position insensitive), the title row values are computed by NewViews.
Title 1 - the company name of the database (i.e. Company Name).
Title 2 - the description of the object (i.e. Description).
Title 3 - the full path name to uniquely identify the object (i.e. odb_path_help).
Print Settings | |||
Line | Field | Values | Comments |
1 2 3 | Title 1 Title 2 Title 3 | Defines up to three titles to be printed at the top of the document. The title lines (if entered) are printed at the top of the table, with Title 1 at the top, followed by Title 2, and finally Title 3. In general, Title 1 is printed using a larger font than Title 2, and Title 2 is uses a larger font than Title 3. (The fonts can be changed by modifying the fonts set in the template.) You can enter title text in any combination of the three Title lines. | |
4 | Print Column Titles | Specifies whether to print the table's column titles. | |
yes | Prints the column title. For non-financial reports, such as sub-ledgers, transactions, employee lists, etc., the column titles should be printed to help the reader understand what the information is. | ||
no | Omits the column title. When printing financial reports such as the Balance Sheet, it is often desirable to set this field to no, as the contents of the columns are obvious. | ||
5 | Print Zero-Balance Accounts | Used to control the printing of accounts. | |
yes | Include accounts whose balance for the period is 0.00. | ||
no | Omit accounts with 0.00 balances for the period. |
Print Settings | |||
Line | Field | Values | Comments |
6 | Destination | Used to control the destination of the output. | |
display | exports to Excel and opens Excel for a preview. | ||
file | Sends output to the file specified in Filename. | ||
printer | Sends output to the printer specified in Printer. | ||
7 | Filename | The output file name. The file type must be {".xls"}, {".xlt"} or {".pdf"}. Important see note on Output File Names options. | |
8 | Printer | If Destination is printer then output is sent to the printer specified here. If this field is empty then output will be sent to the Windows default printer. Press <F3> to select from a list of available printers. NOTE: To clear the Printer field Press <F3> to select from the list of printers, and click on <Cancel> | |
9 | Fit to # pages wide | Shrinks the output, if necessary, to fit on the number of pages wide specified here. | |
10 | Scaling (10 - 400%) | Stretches the output (shrinks or expands). At 100, the page is printed actual size. Settings below 100 shrink the output, and settings above 100 expand the output. | |
11 | Orientation | Used to control the orientation of printed pages. | |
portrait | Prints pages vertically. | ||
landscape | Prints pages horizontally. | ||
12 | Template | The name of an Excel workbook that contains font and page layout information to be used for the table. (Optional) |
If Excel is not running when a table print command is issued, Excel is started and a new workbook is created. A new sheet is then created in the new workbook.
If Excel is running when a table print command is issued, NewViews will synchronize with Excel and the prompt shown above will appear.
The New Workbook option will create a new, unnamed workbook, and then create a new, named sheet within it.
The New Sheet option will create a new, named sheet in the currently active Excel workbook. To append sheets to existing workbooks, switch to Excel, activate the target workbook, switch back to NewViews, issue the print command and select New Sheet.
If you are previewing the document in Excel (Destination is set to display), you can make any desired changes to the format such as adding comments, changing fonts, etc., before printing.
NewViews automatically set the print area, which is indicated on the screen by the dashed border. If you add cells/columns in Excel that you want included in the printout, you must expand the print area as follows:
Issue the command View>Page Break>Preview
Select the cells to be added to the print area
Right click anywhere in the selected area and choose "Add to Print Area"
You can also use the View>Page Break>Preview command to control the pagination of the printout.
To print the document from Excel, use the File>Print command.