I'm running a crystal report from my app. I need to Order By a specific field. The problem is the field is in my group header and it's not the field that is being group. Is there a way to order by another field besides the one your grouping by?

Heres my formula code from inside the app...



VB Code:
  1. rpt.DataDefinition.RecordSelectionFormula = "{pcms_pcard_transaction_header.end_billing_date} =#" & tranPeriodEnd & "# and {pcms_pcard_transaction_header.credit_card_no}='" & ccNo & "'"