vert line

Adding Tags to Reports

In the Report Creator you can drag 'tags' onto the layout. The tags allow you to do things like:

  • Automatically print page numbers on your reports
  • Print the correct date and time
  • Add freeform Text to the report (like a heading, or your name)
  • Print the contents of a particular cell and more

Tags should be dragged into the margin areas of the page. If you place a tag in the main page area, the tag will overprint the data from the Data Ranges, which probably is not the effect you're looking for.

The contents of a Tag will print out on every page of your report.

NB. Don't forget that you can add graphic images - e.g. your Company Logo - to a report just by dragging the image in from the Mac OS X Finder.

There is no special 'graphics' tag. Tags can be moved, resized and inspected (by double-clicking) to change their appearance to the way you want them.

There are tags for:

Page Number - prints the page number, incrementing by 1

Cell - Prints the contents of the specified cell address e.g., whatever is in A23

Date - the date at the moment of printing

Time - the time at the moment of printing

Text - whatever text you want - e.g. 'Compiled by A. N Other'

NB. When you drag a Text tag onto the report, it contains the word 'Text'. To edit this, HOLD DOWN THE ALT KEY AND CLICK THE Text TAG.

Sheet Name - the name of your workbook and the worksheet you're printing

Pathname - the filesystem path to the workbook you're printing.

Tag Inspectors

Double-clicking a tag will bring up the Inspector. Use the inspector to change the borders, the colors, the text alignment in the tag width, and where appropriate the Format (e.g. different Date formats)

See also

 

Also go to:

Index help

Contents help