Crystal Reports - basic question

[Eileen]

Help!
I am trying to create my very first Crystal Report for Actinic.
To begin with, I simply want to list values in one field on the Order table.

Using the Report Expert, I have selected the Database 'ActinicCatalog7' and the Order table.

In Fields, I have selected only the Order Number.

I try to preview, and get the error message:

ODBC error: syntax error in ORDER BY clause

I seem to be missing something very basic.... and it is NOT obvious.

I can select any of the Actinic-supplied reports and preview them in Crystal Reports.... but cannot seem to make the basic connection to the database from my new report.

What am I missing?

[Jan]

Crystal creates a SQL statement using the fields in your report, you cannot use the word order in a SQL statement as a table name, but Actinic has a table called order so you have to set an alias for the order table (Actinic tend to use Orders as the alias) - do this from the database menu using the 'set alias' option.

Regards,

[Eileen]

Thanks ever so much, Jan ...

I was really pulling my hair out over that... it wasted me most of an entire day. I just KNEW it had to be something simple. Sigh.

I tried what you said and BINGO - it burst into life.

Many thanks.

Now I can do what I really wanted to do: play with subreports and functions!

Have a great weekend.