Home

Expressions or Functions used in SSRS

Expressions are usually used for appearance of the data in a report, change properties of the fields, calculate some values and display them in a proper way, compares values between data of fields and then display them. Types of Expressions We have 3 types: Globals Operators - Arithmetic, Comparison,Concatenation, Logical Common Functio...

Read more

How to verify active inventory dimensions on an item

If you want to list items come along with their Actvie Dimension, you can do it easily with this simple job InventTable inventTable; InventDimParm inventDimParm; ; inventTable = InventTable::find('110924'); inventDimParm = InventDimParm::activeDimFlag(InventDimGroupSetup::newInventTable(inventTable)); if(inventDimParm.InventSiteIdFlag)...

Read more

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 repo...

Read more

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 Se...

Read more

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...

Read more

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 : select * from CustTable where AccountNum == '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 ...

Read more