Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update
Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update

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

Arrow left icon
Profile Icon Agarwal Profile Icon Elangovan Profile Icon Aggarwal
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (7 Ratings)
Paperback Mar 2015 352 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Agarwal Profile Icon Elangovan Profile Icon Aggarwal
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4 (7 Ratings)
Paperback Mar 2015 352 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update

Chapter 1. Understanding and Creating Simple SSRS Reports

This chapter will cover the following topics:

  • Using a query as a data source in a report
  • Creating auto designs from datasets
  • Grouping in reports
  • Adding ranges to the report
  • Deploying a report
  • Creating a menu item for a report
  • Creating a report using a query in Warehouse Management

Introduction

Reports are a basic necessity for any business process, as they aid in making critical decisions by analyzing all the data together in a customized manner. Reports can be fetched in many types, such as ad-hoc, analytical, transactional, general statements, and many more by using images, pie charts, and many other graphical representations. These reports help the user to undertake required actions. Microsoft SQL Reporting Services (SSRS) is the basic primary reporting tool of Dynamics AX 2012 R2 and R3.

This chapter will help you to understand the development of SSRS reports in AX 2012 R3 by developing and designing reports using simple steps. These steps have further been detailed into simpler and smaller recipes. In this chapter, you will design a report using queries with simple formatting, and then deploy the report to the reporting server to make it available for the user. This is made easily accessible inside the rich client.

Reporting overview

Microsoft SQL Server Reporting Services (SSRS) is the most important feature of Dynamics AX 2012 R2 and R3 reporting. It is the best way to generate analytical, high user scale, transactional, and cost-effective reports. SSRS reports offer ease of customization of reports so that you can get what you want to see. SSRS provides a complete reporting platform that enables the development, design, deployment, and delivery of interactive reports. SSRS reports use Visual Studio (VS) to design and customize reports. They have extensive reporting capabilities and can easily be exported to Excel, Word, and PDF formats.

Dynamics AX 2012 has extensive reporting capabilities like Excel, Word, Power Pivot, Management Reporter, and most importantly, SSRS reports. While there are many methodologies to generate reports, SSRS remains the prominent way to generate analytical and transactional reports. SSRS reports were first seen integrated in AX 2009, and today, they have replaced the legacy reporting system in AX 2012.

SSRS reports can be developed using classes and queries. In this chapter, we will discuss query-based reports. Reports using classes will be discussed in later chapters.

In query-based reports, a query is used as the data source to fetch the data from Dynamics AX 2012 R3. We add the grouping and ranges in the query to filter the data. We use the auto design reporting feature to create a report, which is then deployed to the reporting server. After deploying the report, a menu item is attached to the report in Dynamics AX R3 so that the user can display the report from AX R3.

Through the recipes in this chapter, we will build a vendor master report. This report will list all the vendors under each vendor group. It will use the query data source to fetch data from Dynamics AX and subsequently create an auto design-based report. So that this report can be accessed from a rich client, it will then be deployed to the reporting servicer and attached to a menu item in AX.

Here are some important links to get started with this chapter:

Using a query as a data source in a report

Queries offer the simplest and easiest way to retrieve data for SSRS reports in Dynamics AX R3. They are very advantageous as they are reusable, and the same query can be used as the data source of another SSRS report in Dynamics AX R3. They are also very easy to design.

We can create queries in two ways: either by using the query class, or under the Queries node in Application Object Tree (AOT). In this recipe, we will create a query under the Queries node in AOT and use it as a data source in SSRS reports. Later on, we will guide you on how to add the query as a data source through Visual Studio.

Getting ready

To work through this recipe, you will require AX 2012 R2 or AX 2012 R3 rich clients with developer permission.

How to do it...

Create a new query named PKTVendorDetails under the Queries node in AOT, and add some fields in the query. Create a new SSRS report in Visual Studio 2010 and add the PKTVendorDetails query into that report as a data source.

  1. Open the AX Development Workspace (Ctrl + D).
  2. Go to AOT | Queries and add a new query.
  3. Rename the query to PKTVendorDetails.
  4. Go to query's data source node and add the new data source.
  5. Rename the data source to VendTable and set property table to VendTable.
  6. There are two steps to select fields from VendTable. You can use any of these:
    • Go to the Fields node under the VendTable data source and set Dynamic Property to Yes. This will automatically add all the fields in the VendTable to the query.
    • Drag and drop the required field directly from the table. Drag VendGroup, AccountNum, InvoiceAccount, and Blocked from VendTable as shown in the following screenshot. This is the best way to optimize the query and, consequently, reduce the fetch time, so we will go for this option in our recipes.
    How to do it...
  7. Save the query.
  8. Now open Visual Studio.
  9. Navigate to File | New | Project.
  10. In the new project dialog, select Microsoft Dynamics AX, and then Report Model.
  11. Set the name as PKTVendorDetailsReport.
    How to do it...
  12. Now, right-click on project in Solution Explorer and Add a new Report to the PKTVendDetailReport project as shown in the following screenshot:
    How to do it...
  13. Rename the report as PKTVendorDetailsReport.
  14. Now open the report by double-clicking on it in Solution Explorer.
  15. Right-click on the Dataset node and select the New Dataset option.
  16. Rename the dataset as VendorMaster.
  17. Now, right-click on the VendorMaster dataset and select Properties.
    How to do it...
  18. Click on the ellipsis (…) button How to do it... in Query.
  19. Select the PKTVendorDetail query from the list and click on the Next button.
    How to do it...
  20. Select All Fields since we dropped all the unwanted fields during the creation of the query. From the All Display Methods node, select Name. Click on the OK button.
    How to do it...

This will generate the fields list for the dataset. This completes the addition of a dataset to a report.

How it works…

In this receipe we have used queries as a datasource in SSRS report in Dynamics AX R3 as queries are reusable and can help to add the ranges in a report.

Connecting VS to AX

When creating a new report project in Visual Studio, if there is no option such as Microsoft Dynamics AX, then ensure that you have your reporting extensions installed. When you have multiple instances of Dynamics AX installed, Visual Studio identifies the instance to connect to from the client configuration. The active client configuration is used to establish the connection. The layer in which the report must be created is also fetched from the client configuration.

Retrieving metadata and data

With AX 2012, Windows Communication Foundation (WCF) based system services have been introduced. This includes the metadata service, query service, and user session service. The SSRS reporting extension uses the query and metadata services. The metadata service helps the report designer in Visual Studio to retrieve the metadata information of Queries, Tables, and Extended Data Types (EDT). The query service is used to fetch the data.

Verify the query

In the case of a complex query, a better approach would be validating the query before it is included in the report. Write a job in Dynamics AX that will use the query to retrieve the data and print the values to the infolog. This will help in identifying the problem when there is an issue with the report.

No joins

The report supports multiple datasets, but as in AX forms these datasets cannot be joined and they remain independent.

Creating auto designs from datasets

There are two ways to design an SSRS report in Visual Studio:

  • Precision design: This is for advanced structured design
  • Auto design: This is for general tabular design

In this recipe, we will create a simple auto design report by using the dataset added in the previous recipe, which will fetch the data and show it in the report.

In auto design, there are layouts that are already built in, and we can choose one in which we want to show the data, based on our preferences.

Getting ready

To develop reports in Dynamics AX 2012 R3, you need Visual Studio, through which you can design, develop, and deploy the reports. SQL Reporting Services must be properly installed and configured. You must also have access to the reporting manager to manage and see the reports present in AX 2012 R3.

How to do it...

In this recipe, we will add an auto design under the Design node of the report. We will then assign its layout properties to ReportLayoutStyleTemplate and print the report.

Note

There are some standard report templates in AX. You can choose any of them for pre-designed layouts.

  1. Right-click on the Designs node, select Add, and then select Auto Design. This will create a new auto design under the Design node. Rename it as VendorMaster.
  2. In the VendorMaster properties, set the LayoutTemplate property to ReportLayoutStyleTemplate and set the Name property to VendorMaster.
    How to do it...
  3. Under the new auto design node, right-click on VendorMaster and select Add | Table. Set the properties for this table as shown in the following screenshot:
    How to do it...
  4. Notice that the fields are added to the table design automatically.
  5. Right-click on Auto design (VendorMaster) and select Preview. This will show a preview of the report.
    How to do it...
  6. To rearrange the fields as per the user requirement, go to the Data node under the Table node. You can move fields in two ways, by:
    • Using the right-click menu options, such as Move to Top, Move Up, Move Down, Move to Bottom
      How to do it...
    • Using shortcuts, like Alt + Up/Down arrow

The new format will look like the following screenshot:

How to do it...

How it works…

Auto design is much easier to design and develop when compared to precision design. The default type (table/chart) for auto design is defined in the properties of the dataset. The default type determines what kind of control is added when the dataset is dragged and dropped into the auto design node.

Templates: Templates are responsible for printing the header, footer, and company name on a report. They also manage the font and colors. Currently, AX does not support printing the company image in the header through auto design.

Report preview: This accesses the default company in AX to show a report preview. So, ensure that the default company in AX has data, otherwise you may not find data in the preview.

Note

Standard SSRS reporting doesn't have the concept of auto design. This is only available in the AX SSRS implementation.

Grouping in reports

Grouping means putting things into groups. In the previous recipe, all the data shown in the report was listed sequentially. Grouping data simplifies the structure of the report and makes it more readable. It also helps you to find details, if required.

We can group the data in the query as well as in the auto design node in Visual Studio. In this recipe, we will structure the report by grouping the VendorMaster report based on the VendorGroup to make the report more readable.

How to do it...

In this recipe, we will add fields under the grouping node of the dataset created earlier in Visual Studio. The fields that have been added in the grouping node will be added and shown automatically in the SSRS report.

  1. Go to Dataset and select the VendGroup field.
  2. Drag and drop it to the Groupings node under the VendorMaster auto design.

    This will automatically create a new grouping node and add the VendGroup field to the group. Each grouping has a header row where even fields that don't belong to the group but need to be displayed in the grouped node can be added.

    How to do it...

This groups the record and also acts like a header, as seen in the following screenshot:

How to do it...

How it works…

Grouping can also be done based on multiple fields. Use the row header to specify the fields that must be displayed in the header. A grouping can be added manually but dragging and dropping prevents a lot of tasks such as setting the row header.

Adding ranges to the report

Ranges are very important and useful while developing an SSRS report in AX 2012 R3. They help to show only limited data, which is filtered based on given ranges, in the report.

The user can filter the data in a report on the basis of the field added as a range. The range must be specified in the query. In this recipe, we will show how we can filter the data and use a query field as a range.

How to do it...

In this recipe, we will add the field under the Ranges node in the query that we made in the previous recipe. By adding the field as a range, you can now filter the data on the basis of VendGroup and show only the limited data in the report.

  1. Open the PKTVendorDetails query in AOT.
  2. Drag the VendGroup and Blocked fields to the Ranges node in AOT and save your query.
    How to do it...
  3. In the Visual Studio project, right-click on Datasets and select Refresh.
  4. Under the parameter node, VendorMaster_DynamicParameter collectively represents any parameter that will be added dynamically through the ranges. This parameter must be set to true to make additional ranges available during runtime. This adds a Select button to the report dialog, which the user can use to specify additional ranges other than what is added.
    How to do it...
  5. Right-click on the VendorMaster auto design and select Preview. The preview should display the range that was added in the query. Click on the Select button and set the VendGroup value to 10. Click on the OK button, and then select the Report tab, as shown in the following screenshot:
    How to do it...
  6. Save your changes and rebuild the report from Solution Explorer. Then, deploy the solution.
    How to do it...

How it works…

The report dialog uses the query service UI builder (that we will cover in later chapters) to translate the ranges and to expose additional ranges through the query.

Dynamic parameter: The dynamic parameter unanimously represents all the parameters that are added at runtime. It adds the Select button to the dialog from where the user can invoke an advanced query filter window. From this filter window, more ranges and sorting can be added. The dynamic parameter is available per dataset and can be enabled or disabled by setting up the Dynamic Filters property to True or False.

Note

The Report Wizard in AX 2012 still uses MorphX reports to auto-create reports using the wizard. The auto report option is available on every form that uses a new AX SSRS report.

Deploying a report

SSRS, being a server side solution, needs to deploy reports in Dynamics AX 2012 R3. Until the reports are deployed, the user will not be able to see them or the changes made in them, neither from Visual Studio nor from the Dynamics AX rich client.

Reports can be deployed in multiple ways and the developer must make this decision. In this recipe, we will show you how we can deploy reports using the following:

  • Microsoft Dynamics AX R3
  • Microsoft Visual Studio
  • Microsoft PowerShell

Getting ready

In order to deploy reports, you must have the permission and rights to deploy them to SQL Reporting Services. You must also have the permission to access the reporting manager configuration.

Before deploying reports using Microsoft PowerShell, you must ensure that Windows PowerShell 2.0 is installed.

How to do it...

Microsoft Dynamics AX R3 supports the following ways to deploy SSRS reports.

Location of deployment

For each of the following deployment locations, let's have a look at the steps that need to be followed:

  1. Microsoft Dynamics AX R3:
    1. Reports can be deployed individually from a developer workspace in Microsoft Dynamics AX.
    2. SSRS reports can be deployed by using the developer client in Microsoft Dynamics AX R3.
    3. In AOT, expand the SSRS Reports node, expand the Reports node, select the particular report that needs to be deployed, expand the selected report node, right-click on the report, and then select and click on Deploy Element.
      Location of deployment
    4. The developer can deploy as many reports as need to be deployed, but individually.
    5. Reports can be deployed for all the translated languages.
  2. Microsoft Visual Studio:
    1. Individual reports can be deployed using Visual Studio.
    2. Open Visual Studio. In Solution Explorer, right-click on the reporting project that contains the report that you want to deploy, and click on Deploy.
      Location of deployment
    3. The reports are deployed for the neutral (invariant) language only.
  3. Microsoft PowerShell:
    1. This is used to deploy the default reports that exist within Microsoft Dynamics AX R3.
    2. Open Windows PowerShell and by using this, you can deploy multiple reports at the same time.
      Location of deployment
    3. Visit http://msdn.microsoft.com/en-us/library/dd309703.aspx for details on how to deploy reports using PowerShell.
  4. To verify whether a report has been deployed, open the report manager in the browser and open the Dynamics AX folder. The PKTVendorDetails report should be found in the list of reports.

    Note

    You can find the report manager URL from System administration | Setup | Business intelligence | Reporting Services | Report servers.

  5. The report can be previewed from Reporting Services also. Open Reporting Services and click on the name of the report to preview it.

How it works

Report deployment is the process of actually moving all the information related to a report to a central location, which is the server, from where it can be made available to the end user. The following list indicates the typical set of actions performed during deployment:

  1. The RDL file is copied to the server.
  2. The business logic is placed in the server location in the format of a DLL.

    Deployment ensures that the RDL and business logic are cross-referenced to each other.

    Note

    The MorphX IDE from AX 2009 is still available. Any custom reports that are designed can be imported. This support is only for the purpose of backward compatibility. In AX 2012 R3, there is no concept of MorphX reports.

Creating a menu item for a report

The final step of developing a report in AX 2012 R3 is creating a menu item inside AX to make it available for users to open from the UI end.

This recipe will tell you how to create a new menu item for a report and set the major properties for it. Also, it will teach you to add this menu item to a module to make it available for business users to access this report.

How to do it...

You can create the new menu item under the Menu Item node in AOT. In this recipe, the output menu item is created and linked with the menu item with SSRS report.

  1. Go to AOT | Menu Items | Output, right-click and select New Menu Item. Name it PKTVendorMasterDetails and set the properties as highlighted in the following screenshot:
    How to do it...
  2. Open the Menu Item to run the report. A dialog appears with the Vendor hold and Group ranges added to the query, followed by a Select button. The Select button is similar to the MorphX reports option where the user can specify additional conditions. To disable the Select option, go to the Dynamic Filter property in the dataset of the query and set it to False.
    How to do it...

    The report output should appear as seen in the following screenshot:

    How to do it...

How it works…

The report viewer in Dynamics AX is actually a form with an embedded browser control. The browser constructs the report URL at runtime and navigates to the reports URL. Unlike in AX 2009, when the report is rendering, the data it doesn't hold up using AX. Instead, the user can use the other parts of the application while the report is rendering. This is particularly beneficial for the end users as they can proceed with other tasks as the report executes.

The permission setup is important as it helps in controlling the access to a report. However, SSRS reports inherit user permission from the AX setup itself.

Creating a report using a query in Warehouse Management

In Dynamics AX 2012 R3, Warehouse Management is a new module. In the earlier version of AX (2012 or R2), there was a single module for Inventory and Warehouse Management. However, in AX R3, there is a separate module.

AX queries are the simplest and fastest way to create SSRS reports in Microsoft Dynamics AX R3. In this recipe, we will develop an SSRS report on Warehouse Management.

In AX R3, Warehouse Management is integrated with bar-coding devices such as RF-SMART, which supports purchase and receiving processes: picking, packing and shipping, transferring and stock counts, issuing materials for production orders, and reporting production as well. AX R3 also supports the workflow for the Warehouse Management module, which is used to optimize picking, packing, and loading of goods for delivery to customers.

Getting ready

To work through this recipe, Visual Studio must be installed on your system to design and deploy the report. You must have the permission to access all the rights of the reporting server, and reporting extensions must be installed.

How to do it...

Similar to other modules, Warehouse Management also has its tables with the "WHS" prefix. We start the recipe by creating a query, which consists of WHSRFMenuTable and WHSRFMenuLine as the data source. We will provide a range of Menus in the query. After creating a query, we will create an SSRS report in Visual Studio and use that query as the data source and will generate the report on warehouse management.

Open AOT, add a new query, and name it PKTWarehouseMobileDeviceMenuDetails.

  1. Add a WHSRFMenuTable table.
  2. Go to Fields and set the Dynamics property to Yes.
  3. Add a WHSRFMenuLine table and set the Relation property to Yes. This will create an auto relation that will inherit from table relation node.
    How to do it...
  4. Go to Fields and set the Dynamics property to Yes.
  5. Now open Visual Studio and add a new Dynamics AX report model project. Name it PKTWarehouseMobileDeviceMenuDetails.
  6. Add a new report to this project and name it PKTWarehouseMobileDeviceDetails.
  7. Add a new dataset and name it MobileDeviceDetails.
  8. Select the PKTWarehouseMobileDeviceMenuDetails query in the Dataset property.
  9. Select all fields from both tables. Click on OK.
  10. Now drag and drop this dataset in the design node. It will automatically create an auto design. Rename it MobileMenuDetails.
  11. In the properties, set the layout property to ReportLayoutStyleTemplate.
  12. Now preview your report.
    How to do it...

How it works

When we start creating an SSRS report, VS must be connected with Microsoft Dynamics AX R3. If the Microsoft Dynamics AX option is visible in Visual Studio while creating the new project, then the reporting extensions are installed. Otherwise, we need to install the reporting extensions properly.

Left arrow icon Right arrow icon

Description

Microsoft 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.

Who is this book for?

Microsoft 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.

What you will learn

  • Create and deploy reports in AX 2012 R3
  • Understand the SSRS report programming flow
  • Modify the reporting framework
  • Create RDPbased reports
  • Design tabular matrices and chartbased reports
  • Debug reports, the reporting framework, and business logic
  • Migrate reports from the legacy reporting framework
  • Get to grips with unit testing and troubleshooting SSRS reports
Estimated delivery fee Deliver to Argentina

Standard delivery 10 - 13 business days

$12.95

Premium delivery 3 - 6 business days

$40.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Mar 27, 2015
Length: 352 pages
Edition : 1st
Language : English
ISBN-13 : 9781784395384
Vendor :
Microsoft
Languages :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Argentina

Standard delivery 10 - 13 business days

$12.95

Premium delivery 3 - 6 business days

$40.95
(Includes tracking information)

Product Details

Publication date : Mar 27, 2015
Length: 352 pages
Edition : 1st
Language : English
ISBN-13 : 9781784395384
Vendor :
Microsoft
Languages :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 120.98
Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update
$65.99
Microsoft Dynamics AX 2012 R3 Financial Management
$54.99
Total $ 120.98 Stars icon

Table of Contents

11 Chapters
1. Understanding and Creating Simple SSRS Reports Chevron down icon Chevron up icon
2. Enhancing Your Report – Visualization and Interaction Chevron down icon Chevron up icon
3. Report Programming Model Chevron down icon Chevron up icon
4. Report Programming Model – RDP Chevron down icon Chevron up icon
5. Integrating External Datasources Chevron down icon Chevron up icon
6. Beyond Tabular Reports Chevron down icon Chevron up icon
7. Upgrading and Analyzing Reports Chevron down icon Chevron up icon
8. Troubleshooting and Other Advanced Recipes Chevron down icon Chevron up icon
9. Developing Reports with Complex Databases Chevron down icon Chevron up icon
10. Unit Test Class and Best Practices Used for Reports Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.4
(7 Ratings)
5 star 57.1%
4 star 28.6%
3 star 14.3%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




adnan baloch May 19, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Businesses depending on ERP to make their decisions have a great need to generate their own customized reports. In Microsoft Dynamics AX 2012 R3, the reporting component is powered by SQL Server Reporting Services (SSRS). This book demystifies the generation of reports using SSRS through easy to understand code samples. However, a sound understanding of object oriented concepts is a prerequisite. The book starts off by showing how to create a simple report using a query as a data source. The formatting of the report is made quick and easy with the help of the auto design feature. Ranges are utilized to help the users filter the data according to their needs. Finally, the report is deployed so it is visible as a menu item in AX. The second chapter tackles sprucing up the report through charts and custom images based on the evaluation of user defined expressions. The next chapter delves into the Report Programming Model in AX and explains how the Model-View-Controller pattern is used in the reporting framework of AX to generate data based on specified parameters and display the report. A particularly useful recipe in this chapter deals with using the same controller for calling multiple reports simulataneously while also handling their security. When reports are dependent on the analysis and consolidation of data provided by the business logic, the Report Data Provider(RDP) comes into play. Creating a report with multiple data sources in a single table as well as displaying company images in the report is made possible thanks to RDP. Connecting SSRS reports with external data sources like XML feeds, SQL server and OLAP are discussed in the next chapter. Adding a map sub report as well as using precision design to create a flexible sub report are also explained clearly. Using charts and gauges and adding validation in reports is made possible with AX 2012. The recipe showing how to upgrade from previous reports is very reassuring to longtime users of Dynamics AX. Surrogate fields introduced in AX 2012 can prove to be quite powerful. However, their proper use is shrouded in mystery for the uninitiated. Two practical examples demonstrate how to leverage surrogate fields in query-based as well as RDP-based reports. A chapter on troubleshooting provides a good deal of solutions for common issues encountered in deployment, rendering and data in reports. Tips are also provided for dealing with barcode generation and improving the performance of language-specific reports like Sales Invoice. Readers plagued by performance problems will particularly appreciate the section showing how to troubleshoot the cause of slowdown by using the free Report Log Viewer tool. The final chapter deals with creating unit classes for contract, controller and RDP classes to aid in testing the feature logic. The book bids adieu to the readers with some great time-saving and productivity-enhancing best practices for report development.
Amazon Verified review Amazon
Brian Apr 05, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Deepak gives you the easy route to become an AX report expert. Great reference book for recall and patterns too!
Amazon Verified review Amazon
gcc Spain May 20, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book drives you, in a very practical way, from the basics of Ax reporting to the most complex scenarios. Troubleshooting and performance tips are also really helpful. In my opinion it is a must for Ax technical community
Amazon Verified review Amazon
Filippo Gallocchio Apr 23, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book!Deepak has huge experience and that's make all easier
Amazon Verified review Amazon
Pradeep May 06, 2015
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Microsoft Dynamics AX 2012 R3 Reporting Cookbook is really a very useful to develop the SSRS report for a beginner level to an expert level. This book is explained in detail of developing a report with detailed screen shots and step by step explanation of development of a report. This book is very useful to me, so suggest to all technical consultants .....
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela