Microsoft Business Apps
Avantiico Industry Solutions
Microsoft Platforms
Licensing & Pricing Options
Explore Microsoft Suite
Dynamics 365
Dataverse
Azure
Office 365
Power BI
Power Virtal Agents
Power Apps
Power Automate
Partner Program
ISV Solutions
Our Partners
Careers
Avantiico Academy Program
Browse Roles
About Avantiico
Events & Webinars
Microsoft Business Apps
Avantiico Industry Solutions
Microsoft Platforms
Licensing & Pricing Options
Explore Microsoft Suite
Dynamics 365
Dataverse
Azure
Office 365
Power BI
Power Virtal Agents
Power Apps
Power Automate
Partner Program
ISV Solutions
Our Partners
Careers
Avantiico Academy Program
Browse Roles
About Avantiico
Events & Webinars
The Microsoft Dynamics AX/D365 Support Team at Avantiico is focused on solving our client’s problems, from daily issues to large and more complex problems.
Last mile delivery is the final step in getting goods from a warehouse or distribution center to the customer’s doorstep. It’s the most visible part
Efficient load planning is the backbone of any successful logistics operation, ensuring goods are transported safely, cost-effectively, and on time. By optimizing truck capacity, balancing
Modern logistics demands more than a static approach; it requires agility, precision, and real-time adaptability. Enter dynamic route planning: a flexible routing method that’s transformed
Optimize your logistics with Microsoft Dynamics TMS, powered by Avantiico’s enhancements like dynamic routing and load planning. Streamline operations, reduce costs, and improve delivery accuracy
AMCS by Avantiico, a robust accounting automation solution native to Dynamics 365, is now offered in free and premium versions. Find out how these solutions
The Task Recorder extension in Dynamics 365 is designed to streamline business process documentation. Learn how to access it, create task recordings, manage and edit
When developing Microsoft Dynamics AX 2012 custom SSRS reports, developers may be required to display data within groups, for example, display budget control transactions by budget group. In these scenarios, it may be required to display information within each group including a group header and subtotal. It may be required to display the group header for each new page, for example if the transactions for a group span multiple pages. It also may be required to allow users to select whether they want each new group to display on a new page.
Advanced properties and code will be used to demonstrate the above. An included XPO project with a sample project for Microsoft Dynamics AX 2012 R3 will be included. A simple table control showing a pre-defined list of customer accounts with a subtotal and grouping by customer account.
> A sample report is included, as a starting point, a simple table control was added:
> On the report table, add a parent group:
> For this demonstration, we will include a header and footer to display the group headings and to print a sub total for the group:
> The report table control should look like this:
> Copy the first column headings to the new row, and delete the first row:
> Click on advanced mode. This will allow us to print the groupings for each new page:
> Set the groupings to print on each new page. If the number of transactions prints across multiple pages, the group heading will always print.
> The left column can be deleted as it is not needed. The report should look like this now:
> Formatting is added to the report, to add a grouping footer total for the amount column:
> Running the report, we can see the groupings and totals:
> The sample data in the report is increased so the data in the first group prints across multiple pages:
> To force new grouping to print on a new page. Click on the AccountNumGroup and right click and select Group Properties. Set the Page Break option:
> Each new group will print on a new page:
> To control whether the groups print on a new page, a parameter was added to the report contract. Since Microsoft Dynamics AX 2012 SSRS reports do not allow expressions to be used to determine whether a page break occurs in a group, we must create 2 tables and hide the tables based on the new page parameter.
> To hide the Tablix, right click on the Tablix properties and set the hidden properties:
> Enter the following expression. This will be used to hide the table control if the ‘new page’ checkbox is not checked:
> Duplicate the table control, disable the page breaks for the AccountNum group, and enter the following as the expression for the Tablix visibility:
> The end result should look like this. The new page checkbox when running the report will control which Tablix to print:
Try it yourself. Run the report included in this blog with and without the new page checkbox:
Last mile delivery is the final step in getting goods from a warehouse or distribution center to the customer’s doorstep. It’s the
Efficient load planning is the backbone of any successful logistics operation, ensuring goods are transported safely, cost-effectively, and on time. By optimizing
Modern logistics demands more than a static approach; it requires agility, precision, and real-time adaptability. Enter dynamic route planning: a flexible routing
Discover how Avantiico helps you improve business processes, provide customers with a seamless experience and transform the way you do business.