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