Skip to main content

Posts

Showing posts from September, 2015

How to add image dynamically from Ax database to SSRS report

Solution : In report design view, create a required table with a data source connection and a dataset with a field that contains binary image data. For more information, see . Insert a column in your table. On the  Insert  menu, click  Image , and then click in the data row of the new column. On the General page of the  Image Properties  dialog box, type a name in the  Name  text box or accept the default. In  Select the image source , select  Database . In the  Image Properties  dialog box, click the expression ( fx ) button. Add following line in expression   = System.Text.Encoding.Default.GetBytes(Mid(System.Text.Encoding.Default.GetString(Fields!IMAGE.Value),8)) In  Use this MIME type , select the MIME type, or file format, of the image—for example, bmp. Click OK.

get Financial dimension from Purchase Order AX 2012 X++

Problem: How to get Financial Dimension from Purchase order AX 2012 X++? Solution : public str getDimensionCombinationValues(PurchTable _purch,str _val) { PurchID _purchId = ""; DimensionAttributeValueSet    dimAttrValueSet; DimensionAttributeValueSetItem  dimAttrValueSetItem; DimensionAttributeValue dimAttrValue; DimensionAttribute dimAttr; Common                  dimensionValueEntity; DimensionValue          dimensionValue; DimensionAliasName      dimensionName; ; dimAttrValueSet = DimensionAttributeValueSet::find(_purch.defaultdimension); while select dimAttrValueSetItem where dimAttrValueSetItem.DimensionAttributeValueSet == dimAttrValueSet.RecId { dimAttrValue =  DimensionattributeValue::find(dimAttrValueSetItem.DimensionAttributeValue); dimAttr      = DimensionAttribute::find(dimAttrValue.DimensionAttribute); dimensionValueEntity =DimensionDefaultingControllerBase::findbackingEntityInstance(curext(),dimAttr,dimAttrValue.EntityInstance); dimensionValue = dimAttr