group by and order by clause

[HRHK]

In CR, I have 3 groups.
Group by Customer id, Contact id, Order id.
Below Group by Order id, I want to display Order#, Item Desc. I would like to display by Item Desc in ascending order. Currently it is displayed by Order#.

How can I do this? Thanks.

 

[lbass]

Is Order# the same as Order ID?

-LB

 

[synapsevampire]

Then group by the description instead, most databases will order rows by the grouped items.

If you want it by order, but within sorted by description, then use the Report->Sort Order and add the description.

This is Crystal version dependent, remember to always post basic info.

-k

 

[HRHK]

Order # is same as OrderID.

I want to group by Order but sorted by description.
I cannot find Report->Sort Order. It is CR 9. Thanks as always.

 

[synapsevampire]

If you GROUP by order, that means they are ORDERED by that GROUP.

Do you mean that you want the details within the order sorted by description.

You keep stating that you want the impossible, you want to order by order, but order by description, please be specific.

Try Report->Sort Expert or Group Sort Expert, depending upon what you want. I think it's the same or similar in CR 9.

You might speak with your dba first and learn what a GROUP is, then this might make more sense to you.

-k

 

[HRHK]

makes sense. Changed group by Item Desc and it works.
Thanks k.