Report Save as Excel Troubles
I created a report using only the following parts: Header Sub Summaries and Footer. When I hit preview the report looks fine and shows only a summary of the grouped records. The problem is when it is saved as an excel file it prints a bunch of duplicate records. Essentially I want the excel sheet to show the groupings and the count of the records in each grouping but it prints out the record count along with the grouping for every record leaving me with a ton of duplicates. I know how to remove these duplicates in excel but it would be nice if I did not have to remove these duplicate records.