Using Display Methods in AX 2012 SRS Reports
The following steps describe how to use a display method as a field when you have a dataset in a SRS report pointing to a query.
1. Display methods cannot be created directly on a query so create a view and add the display methods to the view.
2. Once the view has your display methods on it, use the view as the data source for the query.
3. In Visual Studio, on your dataset point to the query created in step #2. The display methods will be shown in the data set after the list of fields. The icon displayed beside the display method is different from the icon by a normal field but otherwise a display method and normal field are treated the same.
4. In the report's design the display methods are displayed on the data set and can be selected as you would select a field.
-For an example, look at the report CustGrossMarginByAccount_NAReport
-The report CustGrossMarginByAccount_NA uses:
-The view CustGrossMarginByAccount_NA which has 3 display methods on it
-The query CustGrossMarginByAccount_NA which has the view CustGrossMarginByAccount_NA as its datasource
-The SRS report CustGrossMarginByAccount_NA has one dataset which points to the query
Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.
Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.