Max Nguyen

This post is our own opinion and does not necessarily reflect the opinion or view of our companies or Microsoft.

Only integrated security is supported for AX queries

I updated my dynamics Ax development Environment by restoring Database from Production Database . After the restoring the database, when I run any report form Dynamics Ax, all gave error “Only integrated security is supported for AX queries.” The reporting Services are still working fine. For this, best way to redeploy them, create a new report folder, open Microsoft Dynamics Ax 2012 Management Shell (make sure you run Powershell as Administrator).

SSRS Report Server Settings Validation Error- AX 2012 R3 CU9

Recently I updated my dynamics Ax development Environment by restoring Database from Production Dynamics AX DB and I got this problem 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. Anyway, The reporting Services are still working fine and i have already granted the AX Admin as System Administrator under site settings, Home folder settings and DynamicsAX folder with “Browser, Content Manager, DynamicsAXBrowser, My Reports, Publisher, Report Builder” roles.

Link Type and Join Types in ax 2012

Link Type Active: Parent and child data source is updated immediately when a new record in the parent data source is selected. Continuous updates consume lots of resources consuming. Delayed: Parent and child A pause is inserted before linked child data sources are updated. This enables faster navigation in the parent data source because the records from child data sources are not updated immediately. For example, you can scroll a list of orders where you do not want to review the lines associated with the order until you stop scrolling.

How to use operator "or" in QueryBuildRange

This blog post is show how to apply OR conditions in query build ranges in a simple way on same field in a table. Let’s see the simple query : 1 select*fromCustTablewhereAccountNum=='2001'||AccountNum=='2002' We can find out solutions on MSDN by using expression in query ranges, but as it has lot of specifications which needs to be followed. However there is a simple way to do it : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 static void Job12(Args _args) { CustTable cust; Query query = new Query(); QueryBuildDataSource qbds; QueryBuildRange queryRange1, queryRange2; ; qbds = query.

How to install two instances SSRS on one server

Scenario:

I have 2 AOS AX (maybe same in one server or different servers), but only one server for reporting server (I will install and configure multiple SRS instances in this server). Thing is how can we install and configure 2 SSRS instances on same server and running for 2 AOS.

easierly, please take a look the picture below

/imagesposts/two_instances_SSRS_on_one_server_architechture.jpg

Figure 1: Two SSRS instance are running same server.

Problems:

First you need to install 2 SSRS instance in same server, and install reporting service component for first AOS, this step is very simple. The problems come when we install second reporting service component for second AOS.

Reporting service component uses business connector to connect to AX, and it’s saved on configuration in Registry. When we install second reporting service component it will through message that component already installed.

AX 2012 R3 CU8 CU9 and TFS Online 2013 Error

When you try connecting between TFS and Dynamics AX CU8, CU9 and you got error like this: Error 1 Team Foundation services are not available from server ****.visualstudio.com/defaultcollection. Technical information (for administrator): TF400813: Resource not available for anonymous access. Client authentication required. Error 2 Could not load file or assembly ‘Microsoft.TeamFoundation.Client, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified. Client computers that are not running Visual Studio 2010 must have the Team Foundation Server 2010 SP1 Object Model installed to use TFS source control with Microsoft Dynamics AX.

Caching form into AOS to increase performance for Dynamics AX

Scenario: Normally when we open form for the first time in Dynamics AX, it will take sometimes to compilte and cache into AOS. That’s why at second time always faster. If we often restart AOS, how can we keep performance ? Solution: After restart AOS we can let some scripts run to open up some often used forms then cache to AOS, then close those forms. Here is the code

HOW TO USE "LIKE" OPERATOR IN QueryBuildRange

To make something as the LIKE operator in a query, just assign a value to the QueryRange including a wildcard. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 static void QueryBuildRange_Sample(Args _args) { Query query = new Query(); QueryRun queryRun; QueryBuildDataSource qbds; QueryBuildRange queryRange; CustTable custTable; qbds.addDataSource(tableNum(CustTable)); queryRange = qbds.addRange(fieldNum(CustTable, AccountNum)); queryRange.value("axd*"); queryRun = new QueryRun(query); while(queryRun.