|
The Report
Designer department is exactly what it sounds like: it's where all
Reports, Charts and Labels are created and
which populate each Print menu on the Toolbars for each form and
Datagrid. When users choose a print option from the menu, they
may be prompted for additional information.
Overview
Depending on the Print option you select, you may be prompted for
more information such as values for a query filter or choices for
printing labels, etc. Please read the prompts on each dialog
to help you make your selections.
Prompting for Search Criteria
Many times queries for reading data for reports and Quick Views
include prompts to get some search or filter criteria from the user.
Read the name of the field in the label in front of each textbox or
drop-down list, then enter or choose the criteria for filtering the
data. Click ‘OK’ to continue the query and view the results.
The Select Print Options Dialog Overview
This dialog appears when you choose to print a Worksheet from
Datagrid print menu. This gives you a place to add a Title, footer
and choose other options for formatting the printed report.
Features
Title and Title Font - Click the “Font” button next to the
title to change the report title’s font size and style.
Footer - Change the footer by choosing different (or blank)
options from the drop-down lists. Choosing a footer option from the
left drop down list puts the footer on the left side of the page,
the center list in the center, and the right list on the right side
of the page.
Text Font - Set the font size and style for the text in the
Datagridwill by clicking the “Text Font” button. If you have a lot
of data in each cell, choose a smaller font (size 8 or 9) to display
the data better.
Orientation - Set the page orientation; typically a worksheet
prints better in Landscape mode, but you can change it to Portrait.
Choose Grid Style Options - You can choose to print the
gridlines, fit the Datagrid to one page width and to repeat the
column headers on each page.
On The Toolbar
Page Setup - Click this to open the Page setup dialog to
change paper margins or sizes.
Printer Setup - Click this to open the Printer settings
dialog if you need to change from your default printer.
Click OK to show the worksheet in the Print Preview window, or
cancel to close this dialog without printing. NOTE: All
settings you choose in this options dialog will be displayed the
next time you print from the same Worksheet.
Printing Charts
The Chart dialog displays 2-D and 3-D charts and graphs based on the
criteria defined in the Chart print option (in Report Designer).
To view all of the formatting options, right-click anywhere on the
chart to popup the Charting menu, which is laid out in multiple menu
levels.
The Toolbar
Export - You can export the displayed chart in a number of
formats. Click the 'Export' button, then choose the File Type in the
drop-down list at the bottom of the dialog. Choose a location and
enter a file name to save the file.
Animate - This button provides a bit of animation which you
can use to draw attention to your chart if you're doing a
presentation. Click the 'Animate' button, then enter the number of
minutes you want it to run. The Chart will build itself from zero
values to the actual ones, then start over again. You'll also notice
that the rest of the Toolbar buttons have been disabled and the
Animate button is replaced with a 'Stop' button. To shut the
animation off before the timer stops it, click the 'Stop' button.
The animation will continue until the full values are displayed,
then it will end.
Copy - Click this button to copy the current chart to the
Windows Clipboard. Then you can paste it (Ctrl+V) into another
application that supports images.
Style - This button changes the color combinations for the
chart. While you can change each set of color properties
individually by right-clicking on the Chart, clicking on 'Colors'
and then setting the properties, this simply cycles through color
combinations randomly.
Printing Labels
When you choose the Print Labels options from the Print menus
throughout the system, the Label Setup dialog appears. This
setup form lets you choose how to print data from the current page
as Mailing, Return Address or Shipping labels.
Choosing Fields To Print
The drop-down list below 'Choose Field or Enter Text For Each Line'
contains all of the field names from the current page. The five
fields under the drop-down list indicates the five lines of text you
can print on each label. Click on a line, then select a field
and click on it to put it in the line as a placeholder. The
placeholder will be replaced by the actual field value when
printing.
You can also add punctuation and other text on each line. As you add
fields and text, the Label Preview at the bottom displays the
results using the current record you had selected. The “X”
button next to the field drop-down list clears all of the line items
if you want to start over.
Click the “Text Font & Color” button to choose the font size, style
and color for printing. The sample and the preview label will
display your choices.
Using Partial Sheets of Labels
If you have a partial sheet of labels left over from a previous
print job, select the label to start printing on and get its
position based on the label chart. Then make sure it’s the first
sheet of labels in your printer and set the label position in the
“Start On Label No:” drop-down list. The first page of labels will
start printing on that first label and any subsequent pages will
start at position #1.
Print Unique Values
Check this option if you don’t want duplicate labels (based on the
fields selected in the Lines). This is helpful when printing labels
for marking file folders for Accounts, for example, where you would
only want one label for each account name or one label for each
Category.
Printing One Record Multiple Times
To print Return Address Labels, for example, check the “Print
Current Record Only” option, which prints the record you see
displayed in the Label Preview. Then one full sheet of labels will
be created of the same record. Click the Print Preview button to
preview the labels, then print as many pages of labels as you want.
Mailing Labels - Special Features
To create mailing labels, choose the “Mailing” Label Type from the
drop-down list. The image at the right displays the layout for a
standard sheet of labels (Avery® 8160/8460 labels (1" x 2-5/8", 30
labels per sheet), or any other brand the same size). You can print
up to five lines on a mailing label if you keep your font size to
size 10 or under. Use print preview to be sure your labels fit
correctly before printing.
Return Address Labels - The Return Address Label option uses
Avery® 5167/8167 labels (1/2" x 3/4", 80 labels per sheet), or a
similar size in other brands. You should limit the number of lines
to four or less, with a font size of 8 or 9 or less. Use print
preview to be sure your labels fit correctly before printing.
Shipping Address Labels - The shipping labels use any 2”
(high) x 4” (wide), 2 columns x 5 rows labels and can accommodate
all five lines of text. You can make the font size larger on
shipping labels as there is plenty of room.
Printer Setup
Many printers have different margin boundaries; click the 'Page
Setup' button to adjust the margins and pages sizes so that your
labels print without running off the page.
HINT: The first time you print labels, print the first page
on plain paper, then compare the alignment on the paper to your page
of labels. Then if you need to adjust the margins, you won't have
wasted the label pages.
Printing and Previewing
Click the 'Print Preview' button to display the label pages in the
Print Preview window, or click the 'Print' button to send the job
directly to the printer without previewing. It's recommended that
you use the Preview option to ensure your print job looks right
before printing a large number of labels.
Click your browser's 'Back' button to
return to the previous page.
|
|
Crow River Tech, LLC. Copyright© 2010.
All Rights Reserved
Microsoft Windows XP/Vista/7, SQL Server 2005, Access, Outlook and Excel are trademarks of Microsoft
Corporation.
Any other product names are trademarks of their
respective companies. |