AX 2012 - Make SSRS Report Using SQL Stored Procedure

Today we will learn how to create AX SSRS reports using SQL queries/Stored Procedure

Open SQL management studio and navigate to your dynamics AX database. Create a new stored procedure.

Write the query in store procedure according to your need.

Unable to post GRN. Number sequence error

GRN Journal button is not available after PO Posting.
Number sequence could not be generated because a number sequence reference is missing. Ensure that all  necessary number sequences are set up.

Number Sequence Code generates numbers that are longer than the maximum length allowed.

When applying a number sequence to EDT. If you get following error.

Go to the EDT > properties > string size > increase the string size according to the number sequence format length.

AX 2012 SSRS - Cheque report Customization

Today we will learn how to customize standard cheque report and add a new cheque design.

1) Make a new Output type MenuItem for your cheque report.

2) Make changes in the standard enum for cheque report and add your cheque name.

AX 2012 - SSRS : Print duplicate copies of same report

1)Make a string type parameter in your SSRS contract class in which you will save your Report type like Duplicate copy 1,Duplicate copy 2, Extra copy and so on....

2)Then go to your controller class and assign that parameter to your contract.

3)Now in your report dataset you will able to see the parameter, add to your design.

4)Call your report through menu item and pass the parameter in args.parm() method. you can loop through if you want to pass multiple parameters.
Note : to get multiple copies you have to call report multiple times passing different parameter in args.parm() like copy1,copy2,copy3,etc..

and it will get printed now.

Enjoy...!