Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

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

Product type Paperback

Published in Mar 2015

Publisher

ISBN-13 9781784395384

Length 352 pages

Edition 1st Edition

Languages

C#

Tools

Dynamics AX

Concepts

Enterprise Resource Planning

Authors (3):

Agarwal

Aggarwal

Kamalakannan Elangovan

View More author details

Table of Contents (17) Chapters

Microsoft Dynamics AX 2012 R3 Reporting Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

1. Understanding and Creating Simple SSRS Reports FREE CHAPTER

2. Enhancing Your Report – Visualization and Interaction

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

Pre-processing reports

SSRS uses the Windows Communication Foundation (WCF) to connect to the AOS for data access. This connection has a threshold limit and might fail if a report takes a longer time to execute. The report server execution waits for the RDP to process the data and return. In the event where the RDP takes a longer time to execute the reporting service might fail. Pre-processing is a strategy to beat this issue. This recipe will help you understand how to enable pre-processing for any RDP report.

How to do it…

When a report processes a huge amount of data or is found to take considerable time during execution, you can decide to incorporate pre-processing. Follow these steps to enable pre-processing:

Extend the RDP class from the SrsReportDataProviderPreProcess class.
Set the following properties in the temp table used by RDP:

Properties

Value

Table Type

Regular

CreatedBy

Yes

CreatedTransactionId

Yes
The crucial portion of RDP is inserting records in the table with the...

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

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (3)

Agarwal

Agarwal

Deepak Agarwal is a Microsoft Certified Professional who has more than 6 years of relevant experience. He has worked with different versions of Axapta, such as AX 2009, AX 2012, and Dynamics 365. He has had a wide range of development, consulting, and leading roles, while always maintaining a significant role as a business application developer. Although his strengths are rooted in X++ development, he is a highly regarded developer and expert in the technical aspects of Dynamics AX development and customization. He has also worked on base product development with the Microsoft team. He was awarded the Most Valuable Professional (MVP) award from Microsoft for Dynamics AX four times in a row, and he has held this title since 2013. He shares his experience with Dynamics AX on his blog: Axapta V/s Me Deepak has also worked on the following Packt books: Microsoft Dynamics AX 2012 R3 Reporting Cookbook Dynamics AX 2012 Reporting Cookbook Microsoft Dynamics AX 2012 Programming: Getting Started

See other products by Agarwal

Aggarwal

Aggarwal

Chhavi Aggarwal started working on Dynamics AX in 2012. She is a Microsoft Certified Professional and has worked on both the 2009 and 2012 versions of Dynamics AX. She is an expert in SSRS reports and has also done a lot of customization and development in Dynamics AX R2/R3 through X++. She has a very deep knowledge of the technical aspects related to Dynamics AX R2/R3, as well as sound technical and logical skills in customization and development. She has also worked with the Microsoft team for standard base development.

See other products by Aggarwal

Kamalakannan Elangovan

Kamalakannan Elangovan

Kamalakannan Elangovan has over 8 years of development experience in Dynamics AX. He shares a passion for product development and has pioneered multiple ISV solutions on Dynamics AX. In the past, he has worked with Innovites to create the first multidimensional ISV solution for cable industries called "InnoVites for cable". Building the solution from scratch, he gained great insights into building, selling, and promoting a product among customers and partners in the Microsoft Ecosystem. You can find out more about him at http://about.me/casperkamal. Kamal is enthusiastic about sharing his learnings with the community, which led him to create one of the first few blogs for AX in 2006. It is currently available at http://kamalblogs.wordpress.com. He is active on Twitter and is very well known in the community by his pseudonym, "Casperkamal".

See other products by Kamalakannan Elangovan

Personalised recommendations for you

Based on your interests and search pattern

Designing Information Architecture

Designing Information Architecture

Designing Information Architecture is a concise reference on information architecture for UX professionals working within a variety of business contexts for domains like enterprise IA, cross-channel IA, eCommerce IA, and user-generated IA.

Mar 2025 19h 0m

The Ultimate Studio One Pro 7 Book

The Ultimate Studio One Pro 7 Book

This book shows you how to turn your musical ideas into fully produced songs using Studio One's powerful tools and user-friendly workflow, from installing Studio One to mastering and publishing your songs.

Apr 2025 13h 24m

Learn Blender Simulations the Right Way

Learn Blender Simulations the Right Way

This book teaches how to create realistic simulations such as fire, water, and explosions, waving flags, and more using Blender's built in physics system. You'll create animations and gain a deep understanding of all the simulations Blender offers.

Apr 2025 13h 44m

Mastering Clip Studio Paint

Mastering Clip Studio Paint

For artists struggling with the advanced features in Clip Studio Paint, this guide offers step-by-step tutorials and expert tips to master the range of tools, enhancing creativity and efficiency in digital art creation.

May 2025 14h 56m

RxJS Cookbook for Reactive Programming

RxJS Cookbook for Reactive Programming

This book teaches you to craft reactive UI components and animations; leverage browser web APIs; and optimize performance for blazing-fast apps. You'll see how RxJS unlocks elegant solutions for state management and event-driven systems among others.

Mar 2025 10h 20m