When creating a report to print out some data, one can control the order
in which the records are sorted. My problem is that I don't want them
sorted at all, I want them to appear in exactly the same order as in the
underlying table, and they won't!

My data consist of records copied from old file cards. Each card is
identified by a unique name and contains a varying number of records
with four fields, the first of which can be blank.

The data have been entered in a table thus:
Field 1 Fd 2, Fd 3, Fd 4, Fd 5
Card name data, data, data, data
Card name data, data, data, data

Records per card can vary from 1 to c.40

The unique name is used as a group band on the report and I want to
print out the records on each card in identical order so that they can
be checked for data entry errors.

Group name (Field 1 from table)
Record 1: Field 2, Field 3, Field 4, Field 5
Record 2: Field 2, Field 3, Field 4, Field 5
etc.

I haven't selected any field on which to sort the data in the All
records band. However, the records appear in the report sorted on Field
3, which always has data in, and then on Field 2, which may or may not
have data. All records in which Field 2 are blank appear first in
alphabetical order of Field 3, followed by all records in which there is
an entry in Field 2, again in alphabetical order of Field 3.

I tried changing the field order in the Table, putting Field 3 before
Field 2, which merely resulted in the records appearing in the report
sorted on Field 3, ignoring Field 2.

Can anyone show me how to stop the records being sorted in the report,
please?

--
Malcolm

Malcolm

If you have a group band, the output will be sorted on the field used for
defining the group.

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Malcolm" <Malcolm (AT) indaal (DOT) demon.co.uk> skrev i meddelandet
news:h$ru9CYhTikFFwI0 (AT) indaal (DOT) demon.co.uk...

One approach could be to add one field in the underlying table of type
autoincrement.

You can then use that field as the sort for the reports. But as Bertil said,
first of all the report will be sorted by the group band.

Anders

My suspicion is that it has to sort in order to group. But if that's
the case, I'm not sure why it would sort on more than the group field,
or how it figures out which fields to sort on (other than going in order
from the first field).

FWIW,

Liz


Malcolm wrote:

This is correct, if I recall correctly.

To sort otherwise, when group band is present, you need to create new group
bands to get what you want.

As suggested, this could be a + field.

Or, remove the group band and use a multi-level sort.

---------------------------------------------------------
Tony McGuire

that is the default behavior.. once you place a group, the rest of the data
is sorted by field, left to right..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"Malcolm" <Malcolm (AT) indaal (DOT) demon.co.uk> wrote