Mac Works 4.0: Sorting & Grouping in Report Changes Unexpectedly
  
PSS ID Number: Q158643
Article last modified on 10-22-1998
 
4.00
 
MACINTOSH
 

======================================================================
 
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, version 4.0
----------------------------------------------------------------------
 
SYMPTOMS
========
 
When you move fields in List view, some of your reports may be sorted and
subsequently grouped incorrectly; this will happen if all of the following
occur:
 
 - You created a report.
 
 - In the Report Generator, you selected fields to sort.
 
 - You moved that field to another location in List view.
 
RESOLUTION
==========
 
To avoid this problem, you may do either of the following:
 
 - If you have reports set up to sort, do not move fields in List view.
 
   -or-
 
 - Set up your report without any sorting; sort in List view and then go
   to your report.
 
MORE INFORMATION
================
 
When a report is created and you select a field to sort on, the report
locks in on the field location and not the field name. Therefore, if your
database has the following fields:
 
   FIRST    LAST     CATEGORY
 
After creating a report that sorts on LAST, the report will be correct.
If you decide to move fields in List view such as:
 
  FIRST     CATEGORY   LAST
 
then view the previously created report, the report will now be sorted by
CATEGORY instead of LAST. If you also applied any grouping to the report,
the grouping will be incorrect because the report is sorting on the
incorrect field.
 
Microsoft has confirmed this to be a problem in Works version 4.0. We are
researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
 
Additional query words: 4.00 mac m_works re-arrange re arrange wrong
different group
======================================================================
Version           : 4.00
Platform          : MACINTOSH
=============================================================================
Copyright Microsoft Corporation 1998.