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.
=iif(Parameters!ReportDS_NewPage.Value = 0, true, false)
=iif(Parameters!ReportDS_NewPage.Value <> 0, true, false)
Let me know if you have any questions!
The post Advanced SSRS Grouping and Page Breaks in Microsoft Dynamics AX 2012 appeared first on Avantiico.