>Greetings to all,
>
>we have a table with at least 2500 records, these records are sorted by sections and classes, when we print a class list we want to see the late enrollees at the bottom of the record, so what we have tried is to put in a space before the content of the record, the problem is that it goes at the top of the record.
"At the top of the record" - I assume you mean at the top of the list.
>1. We would like to hear some ideas from you guys
>2. Is it posibble to store an unprintable character in a table?
In your SELECT - SQL statement, just add an expression that relates to the date.
For instance:
select * from Inscriptions;
order by iif(date >= {^2002-05-01}, 0, 1), Section, Class;
into cursor Temp
report form Inscriptions
You should make sure the report doesn't have tables in its dataenvironment, if you want to run it against the cursor.
In general, I would not create an index just because I want a certain order on a report - this can easily be done in the SELECT - SQL statement.
If you are not familiar with SELECT - SQL statements, for a quick start, you can use the query builder (CREATE QUERY), and copy the generated SQL statement to your program code.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)