Sorting not appearing to work

[FRED_EMMERICH_(Guest)]

I am using SQL 8.1. I have a group of database records which have a field called AREA. What I want to do is create a sub total for each area in the report, and then rank them by AREA. I set up a sub total for AREA, and made it preprocessed. Then I sort on that. When I run the report, One of my AREA^s shows up in 3 different places in the report. The detail records for each AREA did not seem to stay together. Am I doing something wrong? I am also supressing the body records, but this does not change the way it acts.____Fred

[FRED_EMMERICH_(Guest)]

It appears a simple sort on the AREA field is giving me 3 different breakpoints on AREA, even though they are all the same. None have extra spaces in them and in the software that created this .mdb file, they all show together as the same AREA when I sort them.____Fred

[kfleming]

What are the group fields used in the report?__Is AREA your group level 1 and does your total reset at this level?____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

AREA is my sort and group level 1.

[kfleming]

If you want to send the data file to me, I will have a look to see if I can figure out what is going on.____Kathleen__R&R Support__kfleming@livewarepub.com

[FRED_EMMERICH_(Guest)]

After saving the report, and exiting R&R, I came back in and now the sorting is working correctly. I had been saving all through development of the report but I never left R&R. Very odd.