Invoice Report sorting of detail band by CatergoryName, Product Name

[plang99]

Invoice Report sorting of detail band by CatergoryName, Product Name

Using Northwind.mdb as an example, I tried sorting the Invoices Query but that doesn't do it. I put Order By On in report and then Order By [CatergoryName], [ProductName] and that doesn't do it. I sorted the Order Details Extended and that didn't do it. On the SubReport I put Order By to [Order Details Extended].CategoryName, [Order Details Extended].ProductName and that didn't do it.

What else can I do?

 

[JoeMiller]

Right click on the form, go into "Sorting and Grouping" and change the sorting there. That section overrides all others.

HTH Joe Miller
joe.miller@flotech.net

 

[plang99]

I did that before but productid then categoryid , productname.p

Took out productid and only have orderid, categoryid,
productname.

It now works.

Thanks.

Solved