[Solved] "Newbie to Advocate" problem

[NotYetSenile]

I've been going through this great tutorial and am finally near the end - Reports section. After following the instructions I get to that wonderful step - execute report. No go! Base has inserted "Patient"."Patient Name" into my ORDER BY "Patient Name" ASC step, so it reads -
ORDER BY "Patient"."Patient Name", "Patient Name" ASC
and flags an error (naturally).
Running the basic query works fine. What could I have done wrong?
(I'm tempted to suggest a bug but every time I've found a bug in this tutorial it has turned out to be a mental lapse on my part.)

[Villeroy]

Please post (paste) the full SQL statement.
Tell us about your database software (embedded HSQL or something better?).
Tell us about your reporting software (Oracle Report Builder, plain table report or query dump into spreadsheet?)

[NotYetSenile]

Yes, I should have thought of that.
1. My original SQL statement (copied from the tutorial) -
SELECT CONCAT( CONCAT( "Patient"."Surname", ', ' ), "Patient"."First Name" ) AS "Patient Name", "Phone Number"."Number", "Phone Number"."Description" FROM "Patient", "Phone Number" WHERE "Patient"."ID Number" = "Phone Number"."Patient ID" ORDER BY "Patient Name" ASC
I tried changing the concatenation result to "Patient Full Name" and the ORDER BY likewise. Same result. (There are a few misprints in the tutorial where the names are not exactly the same as those in the database.)
When I looked at the SQL statement in the error message, it read {......ORDER BY "Patient"."Patient Name" "Patient Name" ASC}
Last but not least, I removed the ORDER BY clause altogether.
This time the SQL error statement read {....ORDER BY "Patient"."Patient Name" ASC} !!?
(Sorry. As I write this, I realise I should have closed and re-opened the DB before trying that. Base seems to have a habit of not deleting stuff fully on the fly.)
Finally, I tried ordering by "Description". Worked like a charm, although the output format was a bit messy.

2. Embedded HSQL

3. Oracle Report Builder

[Villeroy]

I don't use the Oracle Report Builder because I find it too complex for my simple requirements and too buggy at the same time.

What I would try:

1. Remove the ORDER BY clause from the query and let the report builder take care of the sorting.
2. Keep the ORDER BY clause in the query and don't let the report builder take care of the sorting.
3. Save the query with "direct SQL mode" and see if it makes any difference (SQL editor's green [SQL] button or menu:Edit>"Run SQL directly).

[NotYetSenile]

Thanks, Villeroy.
My mistake #1. Misinformation. I was using the Wizard, not Oracle Report Builder. BUT ...
It seemed that, even though I was using the Wizard, ORB got in the act as soon as I executed the report. I removed ORB and all was well. Needles to say, I won't be re-installing it! (I had noticed a lot of error complaints about ORB on the forum but they were all old so I guessed it had been fixed. Wrong!)