In this case, a Table report will serve better than Freeform.
1. In the Group Body, place a Value Box bound to State. Using the Property Editor, set it's Visible property to No. By default, it will be named LE0.
2. In the Group Body, place a Value Box bound to City. By default, it will be named LE1.
3. In the Group Header, place an Unbound Value Box. By default, it will be named LE2.
4. Click on the column title where it says "Group Body". The Report Section Properties dialog will appear. From the Break Element dropdown, choose LE0. Leave the Break Value set to 0. Click OK.
5. From the Commands, choose Program Layout. From the Element dropdown, choose LE2. Use the following programming statement:
LE2 = LE0
From the File menu, select Close Programming Editor.
6. Save your report.
This should do what you want, except for a bug where the first State value will not appear. This is because it is trying to print the first Group Header before it has the actual record values. Development will be looking into this.
Quote:I've been following the documentation, which doesn't seem to mention you have to close the design tab before going to preview, so I'm wondering if there's some other instruction missing.
You don't have to close the Design Tab before going to Preview. You do have to save, in order to see your changes, but you can leave the Design Tab open.