Subject Re: Report GroupBy issue using TempTable From Mervyn Bick <invalid@invalid.invald> Date Sat, 26 Oct 2019 20:17:16 +0200 Newsgroups dbase.getting-started On 2019-10-26 3:37 PM, edward racht wrote: > I am printing a report using a temptable having a GroupBy to kick groups > to the next page. > My problem has to do with this situation.  I have two items in a > character field with the same first letter.  They will not separate in > the GroupBy to print on different pages. > I have an Index for the TempTable > Character Field:  SP > S > S Ac > O > B > 3/16 > > As I am having a senior moment here - How do I get the two siimilar > items to Group on separate pages during a report rendering using a > TempTable? > > Ed In the bug-reports newsgroup Ken has pointed out that SET EXACT ON (which is not the default setting) before running the report solves the problem. Mervyn.