How to sort detail lines in grouped report?

Last Post 03 Aug 2007 05:18 AM by rluciano. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Maxer
New Member
New Member

--
24 May 2007 11:15 AM
I have a report that has three levels of groups let's call it:
State - County - City

Then inside the last group (city) is a list of details (perhaps all the zip codes assigned to that city).

Now I want all of the zip codes to be sorted ascending.

I can sort all the states A-Z, all the counties A-z, all the cities A-z, but I can't seem to get any way to sort the detail lines (the zip codes).

How do I accomplish this?

Thanks.
rluciano
New Member
New Member

--
03 Aug 2007 05:16 AM
open the report in the design view and bring up the properties menu of the report. Go to sorting and grouping. It will bring up a little window that shows you the fields being grouped by and sorted by. If city is your last grouping, use the next empty drop down list and select the field you want to sort by.
rluciano
New Member
New Member

--
03 Aug 2007 05:18 AM
Maxer, do you have an account on ARS as well ?
You are not authorized to post a reply.

Acceptable Use Policy