Posts

Showing posts from February, 2015

Covert/Format the Date into dd/MM/yyyy in SSRS - ax 2012

Hi, In SSRS Change the property/Expression of the column like below =Format((Fields!DoB.Value), "dd/MM/yyyy") I found the below link useful which describes more on Format function in SSRS - (A good read) http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/

Error in SSRS in ax 2012 :For more information about this error navigate to the report server on the local server machine, or enable remote errors

Please restart the "Ax services" and "SSRS reporting" services it can be resolve your problem 

How to check a particular dimension is filled or not?

Hi, Use the below code to check whether a dimension is filled or not in the default dimension.       public Boolean checkDeptartmentDimension() {   DimensionAttributeValueSetItem dimAttrValueSetItem; DimensionAttribute dimAttr; DimensionAttributeValue dimAttrValue; Common dimensionValueEntity;   dimAttr = DimensionAttribute::findByLocalizedName( 'Department' ); select dimAttrValueSetItem where dimAttrValueSetItem.DimensionAttributeValueSet == this.DefaultDimension join dimAttrValue where dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue && dimAttrValue.DimensionAttribute == dimAttr.RecId;   if (!dimAttrValueSetItem)      return checkFailed( strFmt ( "Department dimension must be filled in." )); return true ; }