Dynamics Axapta blog

Hello, Error when validate settings in Report servers by any admin account which is not account used to install the AX reporting services extensions. Scenario: In Microsoft Dynamics AX 2012 R2, if i login as an user with admin rights in both AX and SQL reporting services and in AX, under System administration, Setup, Business intelligence, Reporting Services, Report servers after i click "Validate settings", i receive the following error. "Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager." If i login as a user that was used to install the reporting services extensions and deployed the reports and ran the "Validate settings", the settings will be validated as correct. In reporting services report manager site, i have already granted the AX-Admins AD group as System Administrator under site settings, Home folder s...

Hi, Please refer the below link to install and configure multiple instance of SSRS in same box https://technet.microsoft.com/en-us/library/hh389760.aspx Thanks, Vijaykarthik

Hi, Please visit the below link for the above post http://sinedax.blogspot.ae/2012/11/ssrs-report-ax-2012-operation-has-timed.html http://blogs.msdn.com/b/dynamicsaxbi/archive/2013/02/14/how-to-addressing-ssrs-session-timeouts.aspx https://technet.microsoft.com/en-us/library/jj969577.aspx Thanks, Vijaykarthik

Hi, My client have a requirement to change the qty in to 4 decimal place. For this, 1) Go to Data dictionary -> Extended data types -> select Qty (EDT) 2) Open the properties and change the Number of Decimals to 4 ( by default Auto - 2 decimal) 3) Now Go to Unit master in Ax (Organization administration -> setup -> Units -> units) 4) Select the Units and change the Decimal Precision to 4 Note: Please don't change the RealBase EDT. because it has referenced for other than qty EDT. reference : http://www.axsolution.com/?p=332

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/

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

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 ; }