topic Report Designer Issue - Grouped fields in Spatial Data Science Questions https://community.esri.com/t5/spatial-data-science-questions/report-designer-issue-grouped-fields/m-p/654752#M1496 <HTML><HEAD></HEAD><BODY><P>When I create a report based on multiple group fields, the report runs fine, but when I save an RLF and try to run the report later, the grouping is not honored.</P><UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">ArcGIS 10.4.1 (5686) - Advanced</LI></UL><P></P><P>Basically Steps (shown in attachment)</P><OL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Join two tables (1-n).</LI><LI style="margin: 0.2em 0px;">Group on three fields<UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Date (by YEAR)</LI><LI style="margin: 0.2em 0px;">Color</LI><LI style="margin: 0.2em 0px;">Type</LI></UL></LI><LI style="margin: 0.2em 0px;">Sum at then end of the Type group<UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Gallons</LI><LI style="margin: 0.2em 0px;">Applied</LI></UL></LI><LI style="margin: 0.2em 0px;">Run the Report - It is fine</LI><LI style="margin: 0.2em 0px;">Save the Report - reload (same MXD)</LI><LI style="margin: 0.2em 0px;">Run again - The report no longer honors grouping</LI></OL><P></P><P>It seems like a bug.&nbsp;</P><P></P><P>Also, does anyone know if the default Report Wizard is the same in the Business Analyst extension? Is that a more "mature" version of the Report Designer?&nbsp;</P><P></P><P>TIA,</P><P></P><P>Susan</P></BODY></HTML> Mon, 06 Mar 2017 21:50:29 GMT deleted-user-VvvLP0IsAqjw 2017-03-06T21:50:29Z Report Designer Issue - Grouped fields https://community.esri.com/t5/spatial-data-science-questions/report-designer-issue-grouped-fields/m-p/654752#M1496 <HTML><HEAD></HEAD><BODY><P>When I create a report based on multiple group fields, the report runs fine, but when I save an RLF and try to run the report later, the grouping is not honored.</P><UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">ArcGIS 10.4.1 (5686) - Advanced</LI></UL><P></P><P>Basically Steps (shown in attachment)</P><OL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Join two tables (1-n).</LI><LI style="margin: 0.2em 0px;">Group on three fields<UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Date (by YEAR)</LI><LI style="margin: 0.2em 0px;">Color</LI><LI style="margin: 0.2em 0px;">Type</LI></UL></LI><LI style="margin: 0.2em 0px;">Sum at then end of the Type group<UL style="padding: 0px 0px 0px 30px;"><LI style="margin: 0.2em 0px;">Gallons</LI><LI style="margin: 0.2em 0px;">Applied</LI></UL></LI><LI style="margin: 0.2em 0px;">Run the Report - It is fine</LI><LI style="margin: 0.2em 0px;">Save the Report - reload (same MXD)</LI><LI style="margin: 0.2em 0px;">Run again - The report no longer honors grouping</LI></OL><P></P><P>It seems like a bug.&nbsp;</P><P></P><P>Also, does anyone know if the default Report Wizard is the same in the Business Analyst extension? Is that a more "mature" version of the Report Designer?&nbsp;</P><P></P><P>TIA,</P><P></P><P>Susan</P></BODY></HTML> Mon, 06 Mar 2017 21:50:29 GMT https://community.esri.com/t5/spatial-data-science-questions/report-designer-issue-grouped-fields/m-p/654752#M1496 deleted-user-VvvLP0IsAqjw 2017-03-06T21:50:29Z Re: Report Designer Issue - Grouped fields https://community.esri.com/t5/spatial-data-science-questions/report-designer-issue-grouped-fields/m-p/654753#M1497 <HTML><HEAD></HEAD><BODY><P>In case anyone runs into this....</P><P></P><P>This was verified to be a bug -&nbsp;<SPAN style="color: #222222; background-color: #ffffff; font-size: 17.6px;">Esri Case #01901700 - Report Designer<SPAN>&nbsp;</SPAN></SPAN><SPAN class="" style="color: #222222; background-color: #ffffff; font-size: 17.6px;">Bug</SPAN></P><UL style="color: #3d3d3d; border: 0px; font-size: 15px; padding: 0px 0px 0px 30px;"><LI style="border: 0px; font-weight: inherit; font-size: 15px; margin: 0.2em 0px;">Date (by YEAR)&nbsp; - Grouping a date field does not work - have to break the YEAR out as a field in the table.</LI></UL><P>Susan</P></BODY></HTML> Wed, 01 Nov 2017 21:00:24 GMT https://community.esri.com/t5/spatial-data-science-questions/report-designer-issue-grouped-fields/m-p/654753#M1497 deleted-user-VvvLP0IsAqjw 2017-11-01T21:00:24Z