Sorting & Grouping Assistance

[Guest]

Hi. I have a report which sorts/groups by the columns "Due Date" and "Order
ID". Both columns are sorted ASCENDINGLY and both contain both a Group
Header & Group Footer. My users need to see data sorted by "Due Date" which
is why I sort by "Due Date." My users also need to see data grouped by
"Order ID", which is why I use "Order ID" as the second sort/group.

My problem is that data within the "Order ID" group/sort should be sorted by
"Due Date". Basically, I need the group/sort by "Order ID" to only Group by
"Order ID", but not sort by "Order ID". Does that make sense? Basically I
need all data within the report to sort by "Due Date", and currently
everything is sorted by "Due Date", but when the data is broken down by
"Order ID", it sorts by "Order ID" within the Order ID header.

Please let me know if you can help me with this sort, or if I have not
explained this clearly. Thanks.

 

[Duane Hookom]

It would help to see some sample records, similar to what you posted in
Tek-Tips.

 

[Guest]

Hi mike you need two have two reports with only one sort in each. Open the
report. Delete the "Order id" sort. Save the report. Exit the report. Copy
the report. paste the report. it will ask you to name the report. give the
new report a name I sugest you use the old name and add "sorted by Order ID".
Open the new report and then change the sort to "order ID". save the report
and you will have what you need. You might want to add "sorted by Due date"
to the first reports name.

hope this helps
Dev