I have a very simple Master-Detail relationship where the client id is a column in the transaction file. The master table contains the client id, first name, middle, and last and some additional columns. When creating reports in V4.2 I joined the two tables by client id and sorted the output by the client's last and first name and then did the control break on on the client's id. The report would correctly list the output ascending by the client's last name and then first. However, when I try the same thing in V5.1 it is sorting acsending by client id so I no longer have the list ascending by last name but by client id. I recreated the report fresh in V5.1 and still got the unwanted results. If I click on results in the SQL builder everything appears sorted just like I would expect it to be(V5.1). But, when the report runs I get the aforementioned results. I checked the forum to see if someone else has had this experience since it seems so basic that surely someone else should have experienced it.
Is there something radically different between the two versions that I'm missing ???? If I use the last name as the control break it will list the output ascending as desired but then I have no unique value to do the control break by. I can see some work arounds here but before I get into them, I'll have to change all of my reports, I thought I would give the forum a try first. Thanks in advance...
Art
