Sunday, February 27, 2011

Lookup Department Dimension on dialog

Few days back, I received a requirement to show the Department dimension on the report dialog, there are couple of ways to achieve this functionality, but in my opinion, the easiest way to create a new EDT called DepartmentDimension and make a relations to DepartmentDimension == Dimension.num. And 0 == Dinemsions.DimensionCode; where 0 is the dimension you want to use. Finally add following code in the dialog() method of the class:

dialog.addFieldValue(typeid(DepartmentDimension ) ,departmentDimensionVariable ,"Label - if required","help text - if required");

No comments: