Microsoft Dynamics AX 2012 R3 Reporting Cookbook: Over 90 recipes to help you resolve your new SSRS Reporting woes in Dynamics AX 2012 R3

Dynamics AX 2012 is a modern ERP solution from Microsoft that is targeted at mid- and high-level organizations. Reports play a very central role in an ERP system, being accessible to customers, vendors, top management, and the shop floor. Every ERP implementation includes reporting changes as companies try to refit the reports to their processes. Microsoft Dynamics AX 2012 R3 Reporting Cookbook focuses mainly on the reporting aspects of Microsoft Dynamics AX 2012. As a Dynamics AX developer, reporting skills are a must-have and this book intends to make report development easier and simpler. You will gain an understanding of all the various types of report formats such as charts, matrices, tabular in precision, and auto design. This book also offers strategies for new reports as well as for migrating your reports from the old reporting framework and development. Cover 1 Copyright 3 Credits 4 About the Authors 5 About the Reviewers 8 www.PacktPub.com 10 Table of Contents 14 Preface 18 Chapter 1: Understanding and Creating SimpleSSRS Reports 24 Introduction 24 Using a query as a data source in a report 26 Creating auto designs from datasets 31 Grouping in reports 34 Adding ranges to the report 36 Deploying a report 38 Creating a menu item for a report 41 Creating a report using a query in Warehouse Management 43 Chapter 2: Enhancing Your Report – Visualization and Interaction 46 Introduction 47 Creating multiple data regions and charts in reports 47 Creating a chart data region 50 Creating a new layout template 52 Expression in reports 56 Aggregation in reports 59 Adding an image in auto design 61 Formatting reports 63 Adding unbounded parameters in reports 64 Adding filters to data regions 67 Adding document map navigation to reports 69 Creating drill-up/drill-down actions in reports 70 Chapter 3: Report Programming Model 72 Introduction 73 Opening a report through a controller 73 Modifying the report query in controller 78 Opening a report with a dialog 79 Creating a report using the UI Builder class 81 Adding a lookup on a report dialog using the UI builder class 85 Connecting the UI builder class with a contract class 88 Adding ranges from unbound parameters to a query 89 Modifying the UI by caller 95 Turning off a report dialog 96 Setting up security for reports 96 Adding up the report menu item into privilege 97 Calling multiple reports from a controller 100 Calling multiple reports simultaneously using a single controller 101 Debugging a report model 103 Adding data methods in business logic 105 Adding a URL drill through action in reports 107 Debugging business logic 109 Unit testing business logic 110 Creating a report using a controller and the UI Builder class 111 Chapter 4: Report Programming Model – RDP 118 Introduction 118 Creating a simple RDP report 119 Testing the RDP report 126 Creating a simple precision design 127 Creating an advanced RDP report 130 Creating a report with multiple data sources in a single table 137 Creating a group view report 140 Adding headers and displaying company images 145 Using an existing temp table in RDP 146 Pre-processing reports 150 Chapter 5: Integrating External Datasources 152 Introduction 152 Adding a datasource through business logic 153 Using an XML feed as a datasource 156 Building a parameter lookup using business logic 159 Building a report through an external datasource 164 Adding a parameter for an external datasource query 168 Creating a customer summary OLAP report 169 Adding a parameter lookup for OLAP 173 Designing an OLAP table report with SQL Report Builder 179 Designing a map sub-report with SQL Report Builder 187 Creating a sub-report in auto design 193 Creating a sub-report in precision design 196 Chapter 6: Beyond Tabular Reports 200 Introduction 200 Creating a matrix report 201 Creating a multicolumn matrix report 206 Creating a column chart report 209 Creating a line chart 212 Gauges in reports 216 List and rectangle controls in reports 219 Adding reports to the role center 224 Chapter 7: Upgrading and Analyzing Reports 228 Introduction 229 Upgrading a report from its previous version 229 Analyzing and modifying an existing report 233 Implementing validation in reports 237 Surrogate fields in reports 239 Grouping and ordering controls in the report dialog 244 RDP with multiple temporary tables 250 Multi-value lookup 252 Inventory dimensions in reports 256 Financial dimensions in query reports 259 Financial dimensions in RDP reports 261 Chapter 8: Troubleshooting and Other Advanced Recipes 272 Introduction 273 Assessing report performance and usage 273 Handling long-running reports in AX 277 Troubleshooting reports in AX 283 Auto e-mail, save as file tasks in reports 289 Handling events after report completion 291 Generating and displaying barcodes in reports 294 Hiding controls by context 303 Using AXEnumProvider as the dataset for parameters in reports 305 Adding a new report design to print management 307 Deploying language-specific reports to speed up execution time 309 Improving the functionality of reports 310 Chapter 9: Developing Reports with Complex Databases 312 Introduction 312 Creating reports by fetching the data using complex queries 313 Creating reports by fetching the data using views 317 Creating reports by fetching the data using maps 320 Chapter 10: Unit Test Class and Best Practices Used for Reports 324 Introduction 324 Creating a unit test class for a contract class 325 Creating a unit test class for a controller class 328 Creating a unit test class for an RDP class 330 Best practices for AX 2012 report development 340 Index 344 www.it-ebooks.info About This BookEasy and effortless deployment of SSRS reportsOne stop solution for developers to customize existing SSRS reports in Dynamics AX R3Step-by-step tutorial with solutions to writing unit classes for reportsWho This Book Is ForMicrosoft Dynamics AX 2012 R3 Reporting Cookbook is recommended for Dynamics AX developers and.NET-based SSRS developers looking to familiarize themselves with the new AX reporting framework.