I am having difficulties creating a streamlined report that can convey that same information that I would otherwise use Excel or Access for. I have different public work asset inventories I would like to share with management, grouped by multiple fields and summarized by a length or area field for each type. For instance I should have a single row for 18" RCP storm water lines with their summarized length (see attachment). However, when creating a report in ArcGIS Pro, I am not able to create such a report. I can convey the same information in the Detail section, but instead of the data being grouped on one row for each data type, the report creates a row for each entry of that same data type. So, if I have 10 18' RCP storm water lines, the report will have ten rows, one for each 18" line and then I am able to summarize the lengths in the Group Footer section (see attachment). As you can imagine, this can lead to some very long reports. Is this currently possible or being considered in a future update?
