Jill
All reports have a predefined format and ordering. This is defined when the
reports are designed. When you apply a filter on the index and then sort on
screen, this does not change the report sort order, instead, you must
create a different report. This is not hard because you can copy an
existing report, then simply change the sorting. The new report can then be
saved under a new name, then added to the list of available reports on the
Index form. See below for step by step instructions.
Alternatively I have started posting additional reports on our technical
support web site. You will be able to download these reports, then follow
the instructions which are supplied in a text file zipped up with the
reports - unfortunately there is problem with the download - I've asked our
Web site manager to fix it asap.
In the meantime the manual method is as follows:
Login as the system administrator.
Select Adhoc Queries on the main menu.
Select the Reports Tab
Select MonListRpt
Copy it by pressing <Ctrl>C followed by <Ctrl>V - provide a new name when
prompted - eg - MonListSortedByPrefRefRpt
Select the new report and press the Design button
Press the Sorting and Grouping button on the tool bar
In the next available line select the field PrefRef
Close the Sorting and Grouping form
Save the report File >> Save
Close the report
Run the Autoexec macro
Goto the Monument Index
Double click on the Report Pulldown list
In the popup ReportLUT listing, goto the bottom record and enter the name
given to the report in the Name field. A short description in the Desc
field, then MonInventFrm in the FormName field, Rpt in the ObjType field.
Then close the form.
The report should now be on the Report list.
Regards
Tony Pettitt
-----Original Message-----
From: COLLENS, Jill [mailto:[log in to unmask]]
Sent: Monday, October 01, 2001 11:09
To: [log in to unmask]
Subject: Exegesis - printing in sorted SMR number order
A simple (I hope) query for all Exegesis users.
How can I printout a query in PrefRef order? It is possible to sort on
screen by PrefRef, but this does not affect the order that records are
printed in.
Jill Collens
Archaeological Officer
Environmental Planning
Cheshire County Council
Backford Hall
Backford
Chester CH! 2QP
**********************************************************************
Note : This E-Mail is sent in confidence for the addressee only.
Unauthorised recipients must preserve this confidentiality and
should please advise the sender immediately by telephone and
then delete the message without copying or storing it or disclosing
its contents to any other person.
We have taken all reasonable precautions to ensure that no viruses
are transmitted from Cheshire County Council to any third party.
Copyright in this e mail and attachments created by us unless stated
to the contrary belongs to Cheshire County Council.
Any liability (in negligence or otherwise) arising from any party
acting, or refraining from acting on any information contained
in this e mail is hereby excluded.
Should you communicate with anyone at Cheshire County Council by
e-mail, you consent to us monitoring and reading any such
correspondence.
**********************************************************************
|