Skip to Content
0
May 15, 2020 at 04:50 PM

Report shows fewer records after grouping

56 Views Last edit May 15, 2020 at 05:04 PM 2 rev

I have a report in CR. I have a formula field @Month which takes the Month from a string field ie. 13-Oct-2019 results in Oct. Before I group on that field I have 8 records in "Oct, Nov, Dec, Jan, Feb" several records in some of the months. When I group on the @Month field I only get two records... 1 in Feb and 1 in Nov.

The group headers work correctly, but I don't get all the records.

Also, if I sort on that field I get no records.