Problem with report grouping
I can't find anything on this in the forum, so I'm probably doing something wrong. I've created a simple report based on one table with two group headings. The first is Status (either Open or Closed). The second is an ID (that can have duplicate entries as it's a foreign key field). When first created, the report works perfectly, displaying the data as intended. When I revisit it later, it just displays the flat records, i.e. no grouping, regardless of the display mode. I even recreated the report, and exactly the same thing happened again; first run - perfect, subsequent runs - no grouping. Any light shed on this will be most welcome. Thanks.