Sage 100

We have a client who is running Sage MAS 200 v 4.50.3.0 and is having difficulty with a report. The Inventory Sales Analysis - Item Summary Sorted by Year to Date Dollars Sold is NOT actually sorting correctly. The highest grossing items do tend to be sorted first but before the end of page 1 of a 9 page report items will inexplicably ""switch places."" For instance, an item with ""Dollars Sold"" of 100,395.31 will be the line above an item with the amount of 102,138.78. Then items will sort properly for a while and a similar switch will take place. Any ideas?

Are there any other groupings on the report?

No other grouping or sorting that I am aware of.

That report is just using a WRK file, what happens if you create a new report setting?

Usually those reports that have options for different sorting methods write a different key to the work file so the data in the file is in a different order. The report knows nothing about it. The data in the WRK file only exists (if all WAD) for as long as the report is in existence. I suggest previewing the report, while the report is in preview, locate the WRK file, (usually I just sort the data directory by file date and the new one floats to the top), and copy it somewhere safe. Close the report, then go back into the data directory and swap out the ""Master"" WRK file, if you take my meaning, with the WRK copy you saved off with the data in it. Then you can easily dump the data from the new ""Master"" WRK file to Excel and check things out, specifically is the data in the file in the same order as on the report? If so, pay close attention to the keys of the data out of order... , if not - then the issue is likely in the Crystal report itself.