Microsoft KB Archive/158643

Mac Works 4.0: Sorting & Grouping in Report Changes Unexpectedly

PSS ID Number: Q158643 Article last modified on 10-22-1998

4.00

MACINTOSH

=
=========================================================

= 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.