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
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics AX 2012 R3 Reporting Cookbook Update

You're reading from   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
Product type Paperback
Published in Mar 2015
Publisher
ISBN-13 9781784395384
Length 352 pages
Edition 1st Edition
Languages
Arrow right icon
Toc

Table of Contents (12) Chapters Close

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

Building a report through an external datasource


In this recipe, we will create a report that connects to an Online Transaction Processing (OLTP) datasource and retrieves data through an SQL query. You will learn how to add a generic report datasource that can be used across all reports. The report here will retrieve the employee information from the Adventure Works sample database.

Getting Ready

In order to execute this recipe, you will need the Adventure Works database installed in the SQL server. This is available for free to download from Microsoft at http://technet.microsoft.com/en-us/library/ee873271.aspx.

How to do it…

  1. Open Visual Studio and create a project with the name AdventureWorkDatasoure. This project is created to hold the new report datasource in AX.

  2. In the project, add a new element of type ReportDatasource.

  3. Open ReportDatasource and set the following properties:

    Property

    Value

    Name

    AdventureWorks

    Connection String*

    Server=AX2012R2A;Database=AdventureWorks2008R2;Integrated...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image