SQL using Group and Order

[CoachBarker]

Maybe we did not cover this in school, at least not that I can find. I am writing reports using SSRS and I have an SQL Statement. Can I use Order by and Group by in the same statement?

SELECT detail_record.detail_number, detail_record.ticket_number, detail_record.deliver_dt, detail_record.pickup_dt, detail_record.hauler_number,
detail_record.grand_total_wt, detail_record.division, detail_record.pickup_weight, used_ticket_no.pu_date, detail_record.customer_bill_to
FROM detail_record INNER JOIN
used_ticket_no ON detail_record.ticket_number = used_ticket_no.ticket_number
WHERE (detail_record.ticket_number = @ticket_number) AND (used_ticket_no.pu_date = @pickup_dt) AND (detail_record.customer_bill_to = @customer_bill_to)
GROUP BY detail_record.pickup_dt
ORDER BY detail_record.ticket_number

Error Message:


I am learning SSRS at work and I am doing it all on my own so there is no one to ask.