Page 1 of 1
Sorting not appearing to work
Posted: Mon Mar 18, 2002 7:47 pm
by 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
=> Additional info
Posted: Mon Mar 18, 2002 8:02 pm
by 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
==> RE: Additional info
Posted: Tue Mar 19, 2002 7:39 am
by 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
===> RE: Additional info
Posted: Tue Mar 19, 2002 11:26 am
by FRED_EMMERICH_(Guest)
AREA is my sort and group level 1.
====> RE: Additional info
Posted: Tue Mar 19, 2002 2:00 pm
by 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
=====> RE: Additional info
Posted: Fri Mar 22, 2002 4:28 pm
by 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.