A practitioner’s musings on Dynamics 365 Finance and Operations
Hi folks, Today i am searching for sample to write a blog entry for Ax deport development, i found very informative link at msdn which covers all portions of report development in Ax 2012.
http://msdn.microsoft.com/en-us/library/cc653472.aspx
Regards
Ali Raza Zaidi
It is common scenario in report development to use check boxes or radio button as parameter. Any Boolean variable define at data contract class become check boxes at report dialog. But how we make radio button on report dialog. When we require radio button then it means we have more than two values and one value is required to select. For this purpose we have to create a new enum at AOT. Let see we create a new base enum with Name Enum student.
Right click on EnumStudent and open property window and set Style property as Radio button
Now you have to create a new data contract class where we define parameter that will contain the selected value for enum.
[DataContractAttribute]
public class StudentDataContacts
{
EnumStudent enumStudent;
}
[ DataMemberAttribute('Student By'),SysOperationLabelAttribute('Student By')
]
public EnumStudent parmStudent(EnumStudent _EnumStudent =
enumStudent )
{
enumStudent = _EnumStudent;
return enumStudent;
}
When we deploy the report and run from menu Item, Report dialog will be appear like as follow screenshot.
Now questions is that how we used this radio button parameter.
At report level, we can use this radio button parameter for grouping or such other operations. It return string value. For example I used here to just display what value of radio button selected in report Expression as
We can use this parameter inside the Process report method of Data Provider class as
public void processreport()
{
EnumStudent _EnumStudent;
str _StudentType;
StudentDataContact _DataContact;
_DataContact = this.parmDataContract();
_EnumStudent= _DataContact.parmStudent();
_StudentType=enum2str(_EnumStudent);
_TempStudentList.Firstname ="Ali";
_TempStudentList.LastName="Raza";
_TempStudentList.StudentType=_StudentType;
_TempStudentList.insert();
_TempStudentList.Firstname ="Raza";
_TempStudentList.LastName="Ali";
_TempStudentList.StudentType=_StudentType;
_TempStudentList.insert();
}
Hope this helps.
Dynamics Ax provide complex and interactive reports because they help gain valuable insights. One common report requirement is dynamic grouping which allows the users to choose which fields to group their data around.
In SSRS, dynamic grouping can be set up using the following steps.
Define the grouping parameters
To enable a dynamic grouping on a set of fields, create a parameter. List the fields you want to use for grouping and add labels. If you want grouping to be optional, also include null as a value (with a label like “None”).
Select Available Values in the Report Parameter Properties window and add label and value pairs for all groups. Some times Report level parameter is not work, then you have to define this parameter at Data contract class. And used it as report level parameter.
Repeat these steps for each group of fields that you wish to enable dynamic grouping.
Create the report with grouping
Create a table report with the dynamic groups you set up. Groups like month, year and category are very common.
Set the group expression
Open the Group Properties window and Add the desired group expression.
Here is an sample expression where we perform some basic checks on our Month, Year and Category grouping and set the default display.
iif (Parameters!Group1.Value is Nothing,1,Fields(iif(Parameters!Group1.Value is Nothing, “Year”,Parameters!Group1.Value)).Value)
The outer iif checks for empty parameters and displays the entire group if this condition is met.
Otherwise, the second iif checks if the parameter value is Nothing which means none is selected from the drop-down and then it will return the value of the Year field without using it for any sorting or grouping.
Change the grouping display value (label) on basis of selected report parameter
The final step is to change the group label depending on the display value.
In this example, we are setting the Null value to display “Year” as the label in order to match the behaviour in the previous expression.
=Fields(if(Parameters!Group1.Value is Nothing “Year”, Parameters!Group1Value)).Value
This latest dynamics Ax version uses SQL Server Reporting Services (SSRS) as the primary platform for reporting. Developing in SSRS is much faster than X++ making custom reports easier to implement.
In addition to the use of SQL Server tools, there is an integration of the report development environment with Visual Studio 2010 making report development a lot more simple and straight-forward.
Most of the out-of-the-box reports are converted to SSRS platform.
There are two ways to design SSRS reports in AX.
AX 2012 also comes with the drillthrough reporting. This is a popular feature helps developers to link general reports to more specific ones and help the end users find insightful data.
