Inventory dimensions as parameters in the SSRS reports – InventDimViewContract class[Dynamics AX 2012]

Friends,

We all know that inventory dimensions[[Product dimensions, storage dimensions, tracking dimensions] selection is the most commonly asked requirement on SSRS report as parameters.

Let me show what exactly we are trying to achieve in this post. In the below screen shot, we have all the inventory dimensions for selection.

InventDimViewContract class will help you to get this as it contains the inventory dimensions view data contract for SSRS reports. It is general data contract for inventory dimensions. This contract is used for selecting the dimensions to print.

[Please note: This post will only cover how to display these inventory dimensions as parameters on SSRS reports]

image

Below is the screen shot of InventDimViewContract class which has all inventory dimensions as parm methods.

image

How to use the above InventDimViewContract class? Well, its very simple.

In your Data provider class use InventDimViewContract class as SRSReportParameterAttribute as shown below.

SRSReportParameterAttribute(classStr(InventDimViewContract))

image

You can find so many reports which uses this contract class, Refer to class: InventOnHandDP for more details.

Dax6ng,

sree

Duplicate SSRS Reports wizard with artifacts [Data provider, Contract, UIBuilder, CSharp project [Dynamics AX 2012]

Friends,

This post is an extension to my earlier post to duplicate SSRS reports in AX 2012 with some fixes/improvements and additions.

There were several requests from the readers that it would be of more help if the utility can even duplicate DP class, Contract class and UIBuilder classes. After enough research and analysis of the framework, I was able to do this technically.

Below is the wizard preview. [This wizard will take 5-20 minutes to duplicate all the artifacts but I believe its worth waiting as to create these classes and use them in report, it would take more time for a developer.]

Interested readers please contact me for a copy of the wizard.

image

 

image

image

image

image

Below is the private project which the wizard creates for you with the required classes , report and CSharp business logic project.

image

That’s all for now.

Happy Dax6’ng

sree

How to find out the source of data on SSRS reports [AX 2012]

Friends,

I know most of the developers are interested to find out the source of the data on any report. It’s actually very simple.

Right-click on any report >> Add-Ins >> Cross-reference >> Using (instant view).

image

This complete cross-reference form will help us to identify the source of data in detail along with the report data source, Labels, Table fields etc.

The below screen shot details about the AccountantInvestmentAnlaysis report which comes from the source : OLAP

image

The same can be easily understood by expanding the Designs >> Role center

image

If we take SalesConfirm report: we can easily identify that the data that is getting rendered on to report is coming from SalesConfirmHeaderTmp and SalesConfirmDetailsTmp tables and from the fields in it.

image

The same can even be seen by expanding the designs >> Report >> Permissions >> Tables

image

Happy Dax6ng,

sree