| Report
Modification - Overview/Commands/Fieldnames
We will touch
on the basics of modifying the format of a report.
Keep
in mind:
- Press CTRL
and F10 together to maximize the Modify
window to see the report format on a full screen.
- Test all
your changes on scrap paper; do not use your valuable
card or label stock until you are sure you have the
results you desire.
- If printing
labels or cards, don’t indicate that they have
all printed successfully until after
you have the final labels or cards in hand.
- There are
several "Modify" examples for specific situations
on the main support
page.
- It's recommended
that you use the supplied "Spare" reports for doing
your modifications.
- Filling
in the Substitute Title for Report field on the Report
Options screen when modifying one of the “Spare” reports forces ResourceMate® to
memorize your substitute title when
you Preview the report. It will also replace the
default
Spare report title on the Report Options screen. This
will help you remember the specific modifications you
made to the selected Spare report. This is also a good
reason to use the Spare reports when doing custom sorting
or other modifications.
Selecting ALL Objects
Double-click on the horizontal dividing bar called "Detail"
and all the objects in the "Detail" area will
be selected. (Small squares or "handles" will
appear around the box’s edges and corners).
Selecting
Objects One at a Time
Click on the object. Small squares or "handles"
will appear around the box’s edges and corners.
To select more than one object at a time: Method
#1: for each additional object, press the SHIFT
key while selecting the object. Method #2:
Press and hold the left mouse button down, then drag the
mouse down and to the right to create a selection box
that encloses all or part of all the object you wish to
select. When you release the mouse, those objects that
are fully or partially inside the selection box will become
selected.
Cancelling
One or All Selections
Either click again on a selected object, or click once
on a place in the template that currently holds no
object. This will unselect all the objects currently selected.
Move
an Object
Once the object is selected, use the arrow keys to move
the object on the report.
Changing
the Size of an Object
Method #1: select the object; hold the
SHIFT key down while pressing the left
or right arrow keys. This will make the object shrink
or grow.
Method #2: Select the object; using the
mouse, click on one of the black square "handles"
on the object’s edge—continue to hold the
mouse button down and drag the handle to a new location.
Delete
an object
Select the object and press the Delete
key.
Change
the Margins
Click on the Report menu (careful:
not the Reports menu but the Report menu which
is all the way to the right). Click on Report Layout.
The data entry box below the "Columns" box defines
the left margin. You can use the tiny up and down arrow/triangles
to adjust this value. This will move all the report/card/label
text left or right on the page. Note that this number
can go negative.
Change
the Font or Style of the Letters
Select the object (see instructions on selecting
objects); go to the Object menu, click on
Font...; make your changes then press Ok.
Change
a Column Heading or Other Text not Enclosed in a Box
With your mouse, press the large capital "A"
button on the left edge of the Modify window. Your cursor
will change to a vertical "I-beam"
for text entry. With this new cursor click once anywhere
on the text you wish to change. Modify the text using
the delete, backspace and letter keys. Click the button
above the capital "A" button (up-pointing arrow).
Adding
Fields to a Report
Method
#1 – Copy an existing object:
select an existing object (here's how).
Press CTRL and C to
copy the object then press CTRL and V
to paste the new copy which will appear slightly offset
from the original object. Drag the new object to the desired
screen location (using arrow keys for fine tuning). Double-click
on the new object to bring up the "Report Expression"
box. Continue to next step after method #2 below...
Method #2 – Use the "[ab]"
tool: with your mouse select the button marked
[ab] on the toolbar on the left of the
screen. Your cursor will change to a plus sign. Click
and hold the left mouse button down while positioning
the mouse over the space where the new field will go.
Then drag the mouse (while still holding the left mouse
button down) down and to the right to draw the box in
the desired size. When you release the mouse you will
see the "Report Expression" box. Continue to
next step...
Entering
field name in "Report Expression" box
Click in the box immediately to the right of the "Expression…"
button. Enter the name of the new field to this box. (Note:
see the tables below for the
name of the field to enter) Press OK.
Saving
your Changes
Go to the File menu and select Close.
The program will ask you if you want to save your changes:
click Yes if you do, or click No
to discard the changes you have just made.
Quitting
Without Saving the Changes You've Made
Go to the File menu and select Close.
The program will ask you if you want to save your changes:
click No to discard the changes you have
just made.
Also click
on the following links for more details on modifying reports
(the first link is this file):
Report Modification
- Overview/Commands/Fieldnames
Report Modification - Name Report - change so
name is reported as last name, first name
Report Modification - Series Report - change
so it just lists Series names, not items
Report Modification - Library Labels - change
so labels print title, sub-title and series
Report Modification - Library Labels - change
so labels print title and sub-title
Report Modification - Library Labels - change
so labels print author, 2nd author and 3rd author
Report Modification - Library Labels - change
so labels print author and 2nd author
Report Modification - Cards - add donor
information to the shelf or inventory card
Report Modification - Cards - add sub-title to the top line of the Title
card
Report Modification - Cards or Labels -
Change the font size
Report Modification - Cards or Labels don't
line up on stock properly
Report Modification - Adding the "cut paper" command
for Receipt printers
For further clarification of these Report Modifiation instructions,
please feel free to contact us.
Fields
on the ITEM File (Click
for fields on the NAME file /
on the MEDIA file)
| Field
Name |
Type |
Width |
Decimals |
Description |
| Title |
Character |
60 |
|
Title |
| Subtitle |
Character |
90 |
|
Sub-Title |
| Series |
Character |
45 |
|
Series |
| Number |
Numeric |
2 |
|
Copy
Number |
| Author |
Character |
45 |
|
1st
Author |
| Author2 |
Character |
45 |
|
2nd
Author |
| Author3 |
Character |
45 |
|
3rd
Author or Illustrator |
| Responsib |
Character |
45 |
|
Statement
of Responsibility |
| Publish |
Character |
45 |
|
Publisher |
| PubDate |
Character |
12 |
|
Date
Published |
| PubPlace |
Character |
30 |
|
Place
of Publication |
| Call1 |
Character |
8 |
|
Call
Number 1 |
| Call2 |
Character |
8 |
|
Call
Number 2 |
| Call3 |
Character |
8 |
|
Call
Number 3 |
| Call4 |
Character |
8 |
|
Call
Number 4 |
| Call5 |
Character |
8 |
|
Call
Number 5 |
| Loc |
Character |
15 |
|
Location |
| Order |
Numeric |
7 |
|
Order
within Location |
| Cat |
Character |
20 |
|
Category |
| Level |
Numeric |
4 |
1 |
Difficulty
Level |
| Type |
Numeric |
3 |
|
Resource
Type (corresponds with mdcode on media.dbf)
|
| ItCode |
Character |
10 |
|
Internal
item identifier |
| CombCode |
Character |
20 |
|
Internal
combination of STR(Type)+ItCode |
| Pages |
Numeric |
5 |
|
#
of pages [books]; # of minutes [CD's, videos etc] |
| PurDate
|
Character |
10 |
|
Date
Purchased |
| Status |
Character |
30 |
|
Status |
| RpValue |
Numeric |
7 |
2 |
Replacement
Value |
| ValueTf |
Logical |
1 |
|
Include
in Mass Replacement Value |
| NumLoan |
Numeric |
3 |
|
Number
of times loaned |
| Loaned |
Date |
8 |
|
Date
last loaned |
| Expect |
Date |
8 |
|
Date
expected back |
| Loanper |
Numeric |
7 |
|
Last
person to Loan (corresponds with nmcode on name.dbf) |
| Return |
Date |
8 |
|
Date
Returned |
| Returnd |
Logical |
1 |
|
Returned? |
| LFiction |
Logical |
1 |
|
This
item is fiction |
| LAuthor |
Logical |
1 |
|
Print
1st Author Card |
| LAuthor2 |
Logical |
1 |
|
Print
2nd Author Card |
| LAuthor3 |
Logical |
1 |
|
Print
3rd Author Card |
| LResponsib |
Logical |
1 |
|
Print
Statement of Responsibility Card |
| LInvent |
Logical |
1 |
|
Print
Inventory (Shelf) Card |
| LTitle |
Logical |
1 |
|
Print
Title Card |
| LSubTitle |
Logical |
1 |
|
Print
Sub-Title Card |
| LSeries |
Logical |
1 |
|
Print
Series Card |
| LSubject |
Logical |
1 |
|
Print
Subject Card |
| LSpine |
Logical |
1 |
|
Print
Spine Label |
| LSignout |
Logical |
1 |
|
Print
Signout Card Label |
| LPocket |
Logical |
1 |
|
Print
Pocket Label |
| ISBN |
Character |
20 |
|
I.S.B.N. |
| LibCon |
Character |
20 |
|
Library
of Congress |
| Accession
|
Numeric
|
8 |
|
Accession
Number |
| AccDate |
Date |
8 |
|
Accession
Date |
| HardSoft |
Character |
4 |
|
Hard
of Soft Cover |
| FictDiv |
Character |
5 |
|
Section
(found above call numbers) |
| LibNotes |
Memo |
* |
|
Librarians
Notes (after Series information) |
| ShelfInfo |
Character |
100 |
|
Shelf
Card Information |
| Biblio |
Memo |
* |
|
Bibliography
information |
| Bar |
Numeric |
16 |
|
Bar
Code Number |
| BiblioYn |
Logical |
1 |
|
Include
in Bibliography Report |
| PubInfo |
Memo |
* |
|
Body
of Card Information |
| Notes |
Memo |
* |
|
Notes
Tab |
| UC1 |
Character |
30 |
|
User
Defined Character Field 1 |
| UC2 |
Character |
30 |
|
User
Defined Character Field 2 |
| UC3 |
Character |
30 |
|
User
Defined Character Field 3 |
| UC4 |
Character |
30 |
|
User
Defined Character Field 4 |
| UC5 |
Character |
30 |
|
User
Defined Character Field 5 |
| UN1 |
Numeric |
7 |
2 |
User
Defined Numeric Field 1 |
| UN2 |
Numeric |
7 |
2 |
User
Defined Numeric Field 2 |
| UN3 |
Numeric |
7 |
2 |
User
Defined Numeric Field 3 |
| UN4 |
Numeric |
7 |
2 |
User
Defined Numeric Field 4 |
| UN5 |
Numeric |
7 |
2 |
User
Defined Numeric Field 5 |
| UD1 |
Date |
8 |
|
User
Defined Date Field 1 |
| UD2 |
Date |
8 |
|
User
Defined Date Field 2 |
| UD3 |
Date |
8 |
|
User
Defined Date Field 3 |
| UD4 |
Date |
8 |
|
User
Defined Date Field 4 |
| UD5 |
Date |
8 |
|
User
Defined Date Field 5 |
| UL1 |
Logical
|
1 |
|
User
Defined Logical (Yes/No) Field 1 |
| UL2 |
Logical |
1 |
|
User
Defined Logical (Yes/No) Field 2 |
| UL3 |
Logical |
1 |
|
User
Defined Logical (Yes/No) Field 3 |
| UL4 |
Logical |
1 |
|
User
Defined Logical (Yes/No) Field 4 |
| UL5 |
Logical |
1 |
|
User
Defined Logical (Yes/No) Field 5 |
| UM1 |
Memo |
* |
|
User
Defined Memo (Notes or Comments) Field 1 |
| UM2 |
Memo |
* |
|
User
Defined Memo (Notes or Comments) Field 2 |
| NewR |
Logical |
1 |
|
Internal
Use |
| Picture |
General |
10 |
|
Multimedia
Object (Plus version only) |
|
* memo fields are variable in length; they stretch
to fit the actual data stored in them. |
Fields
on the NAME/PATRON File (Click
for fields on the ITEM file /
on the MEDIA file)
You can modify
the Address Labels format with these field names (Plus
version only).
| Fieldname
|
Type |
Width |
Decimals
|
Description |
| nmlast |
Character |
20 |
|
Last
name |
| nmfirst |
Character |
20 |
|
First
name |
| nmcompany |
Character |
30 |
|
Company
name |
| nmhomeph |
Character
|
36 |
|
Home
phone number |
| nmbusph |
Character |
36 |
|
Business
phone number |
| nmcarph |
Character |
36 |
|
Cell
phone number |
| nmfaxph |
Character |
36 |
|
Fax
number |
| nmemail |
Character |
36 |
|
E-mail
address |
| nmgrade |
Character |
20 |
|
Grade |
| nmtitle |
Character |
10 |
|
Title |
| nmadd1 |
Character |
30 |
|
Address
line 1 |
| nmadd2 |
Character |
30 |
|
Address
line 2 |
| nmcity |
Character |
20 |
|
City |
| nmprov |
Character |
5 |
|
Province
/ State |
| nmcountry |
Character |
20 |
|
Country |
| nmpostal |
Character |
10 |
|
Postal
code / Zip code |
| nmcomment |
Memo |
* |
|
Comments |
|
* memo fields are variable in length; they
stretch to fit the actual data stored in them. |
Fields
on the MEDIA/RESOURCE TYPE File (Click
for fields on the ITEM file /
on the NAME file)
| Fieldname |
Type |
Width |
Decimals |
Description |
| mddesc |
Character |
30 |
|
Resource
type name (i.e. "Books", "Compact Discs") |
| mdshort |
Character |
5 |
|
Resource
type short name (i.e. "CD"). Used
on some reports where there is not enough room
for the long name. |
| mdperiod |
Numeric |
3 |
|
Loan
period (in days) |
| mdfine |
Numeric |
5 |
2 |
(Plus version) Fine per day for overdue items of
this resource type |
| mdseries |
Character |
10 |
|
Substitute field label for the "Series"
data field |
| mdtitle |
Character |
10 |
|
Substitute
field label for the "Title" data field |
| mdsubtitle |
Character |
10 |
|
Substitute
field label for the "Subtitle" data
field |
| mdauthor |
Character |
10 |
|
Substitute
field label for the "Author" data field |
| mdauthor2 |
Character |
10 |
|
Substitute
field label for the "Author2" data field |
| mdauthor3 |
Character |
10 |
|
Substitute
field label for the "Author3" data field |
| mdpub |
Character |
12 |
|
Substitute
field label for the "Publisher" data field |
| mdpubdate |
Character |
15 |
|
Substitute
field label for the "Publication date" data
field |
| mdpubplace |
Character |
12 |
|
Substitute
field label for the "Place of publication" data
field |
| mdpages |
Character |
10 |
|
Substitute
field label for the "# of pages" data field |
| mdsubject |
Character |
10 |
|
Substitute
field label for the "Subject" data field |
| mdmaterial |
Character |
25 |
|
Material
description (i.e. "[video recording]") |
| mdcode |
Numeric |
3 |
|
Internal
record identifier |
| marctype |
Character |
1 |
|
Type
of MARC record associated with this resource
type |
|