9. Use Queries to Write a Report With Multiple Sort Orders

Define query order-query for order.

Case sort-order:

When “Sales rep” then

Open query order-query

For each ord-hdr no-lock

where ord-hdr.order-date >= from-date

and ord-hdr.order-date <= to-date

by ord-hdr.add-user

by ord-hdr.order-no.

When “Order” then

Open query order-query

For each ord-hdr no-lock

where ord-hdr.order-date >= from-date

and ord-hdr.order-date <= to-date

by ord-hdr.order-no.

End case.

Previous slide

Next slide

Back to first slide

View graphic version