O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a report with multiple data sources in a single table

In this recipe, we will create an SSRS report using the RDP concept with multiple data sources. The process method of the RDP class is used to write the business logic in the report and to insert the data into the temporary table. In the previous recipe, we took only one temporary table, but in this recipe, we will take one more temporary table and use both the temporary tables in a single table in the SSRS report.

How to do it…

  1. The first step is to create a new temporary table called PktItemTableTmp with the fields indicated here:
    How to do it…
  2. Now we will insert the data into this temporary table in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required