Has anyone else encountered problems when using Crystal Reports and the Native Baan driver, and having more than one group on the report? Or am I just to silly to use Crystal Reports?

I have one group: tccom010.nama
and a second group tdsls040.orno

They are sorted like this, first Customer name, then Order number.

However, my output is always sorted by order number, and I get a new Customer header for each order (not sorted by name, but by the orders).

What am I missing here?

First, have you tried contacting Crystal Support? They have always been able to resolve issues for us.

Second, check your "File - Options - Database" and see if you have "Grouping on Server" checked and also check to see if it is checked in the "File - Reports Options" as well. There is an issue with passing grouping control to the Baan driver which does not seem to perform it. Since Crystal thinks that the grouping/sorting is already done on the returning data, it does not do any further sorting or grouping at the local level. When we disabled the Group on Server it immediately resolved the problem.

Third, I'm sure this is not improving your opinion of Crystal and the Baan driver. Crystal Decisions very much cares about customer satisfaction and improving their products. They do listen to their customers. I know, because they have listened to me.