Page Total and Running Total in SSRS AX 2012

In SSRS Reports, you can easily make use of running totals on every page of your report. SQL Server Reporting Service does not have a standard functionality for this.  Here I will explain how you can implement running totals in your report.

  1. Add a tablix to your report and add a dataset to it. In my example I have 3 columns:
    Debtor code, Account Name and Outstanding amount.
  2. Add a 4th column to the tablix. Set the visibility of this column to Hide.
  3. Select in the 4th column the detail row. Select Text Box Properties and change the name of the textbox to ‘RunningTotal’.
  4. Select Value and press the expression button. In this expression we will define the running total of the column. In my example, I have a columns Outstanding from the dataset ‘CreditLimitDetails’

    Now we have a running value of the outstanding amount in the 4th column.

  5. To display the running value on every page, we will use the page footer.
  6. Add a page footer to your report. In BIDS you can select, Report, Add Page footer.
  7. In this example I will add a page total and a running total to the report.
  8. Insert a 2 text boxes to the page footer.
  9. Open the expression definition of the first text box. In this text box we will define the totaal outstanding amount of the current page.
    =”Page Total: ” + cstr(Sum(ReportItems!Outstanding.Value))
  10. Open the expression definition of the second text box. In this text box we will define the Running total of the outstanding column of the current page and all previous pages.
    =”Running Total: ” +cstr(Last(ReportItems!RunningTotal.Value))

Now your report will print running totals at the bottom of every page.

Introduction to AX 7

User experience and interface

Dynamics AX, going forward, will evolve and grow as the firm evolves and grows, thus transforming the way businesses operate.

In its appearance, AX 7 will have similarities to Office 365. It will introduce efficient workspaces adjusted to the user’s role and activities, with integrated Power BI, dashboards and real time analytics.

Dynamics AX 7 will also include a web-based HTML5 client experience and will be accessible from any device, on any browser. Tablets will be the first to benefit from this improvement, Smartphones will follow at a later stage.

To handle those changes, developers will have access to productive tools for web development. The integration with Visual Studio will be deeper and more engaging for developers.


Functionalities and focus

Functionally, Dynamics AX 7 is based on 2012 R3 CU8. Some elements will be duplicated, while some functionalities will be improved and approached in a different way.

Microsoft Dynamics AX 7 is part of the wider One Microsoft breadth of solutions and fully supports Microsoft’s ambitions of 1) Reinventing productivity and business processes, 2) Building the intelligent cloud platform, and 3) Creating a more personal computing.


Help and support

Help and support will evolve significantly. The traditional help service will change into a more collaborative experience.


Dynamics AX 7 release

The final version of AX 7 is expected be announced at Convergence 2015 (between November 30th and December 2nd). The pricing model will be announced as well.  General availability will follow Convergence.

At first, AX 7 will only be deployable on Azure through Lifecycle Services (LCS). This means that Dynamics AX consultants who haven’t used LCS yet will need to become familiar with it. Independent consultants who don’t have LCS access can easily obtain it – see how.


Roadmap for Dynamics AX 2012 R3/AX 7


This September, Microsoft will start to make the AX 7 preview edition available so that users can begin exploring it and giving feedback. The release date will be determined based on the data gathered at that stage.

After the release, there will be half-yearly update cycles where additional update models will kick-in.

The upgrade of existing customers won’t be available in the first release of AX 7 – it will follow in an additional release.

Over 40 languages will be available at launch.

If you have recently invested in Dynamics AX 2012, you’ll be interested to know that AX 2012 R3 will be continuing for the foreseeable future.


Consultants – How to get ready

Essential skills

– Get up-to-date with certifications at the AX 2012 CU8 level: the baseline functionalities of AX 7 are similar to those of the CU8 release. Having this level of knowledge will mean you’ll only need to learn about the new user experience.

– Learn how to work with Azure and Power BI – they will be central to Dynamics AX 7 implementations.

– For developers, HTML 5 will be a must-have and you’ll need to know how it works with Visual Studio.

– Learn how to use Lifecycle Services.


New Certifications

From January, there will be 4 courses available resulting in 4 certifications.

Two which already exist but will be revised and updated:

– Microsoft Dynamics AX Trade and Logistics
– Microsoft Dynamics AX Financials

Two which are new for Dynamics AX 7:

– Microsoft Dynamics AX 7 Development introduction
– Microsoft Dynamics AX 7 Installation & Configuration

Refresh Listpage from Child form AX 2012

You often open a dialog or drop dialog when you are working with another form. As a result, you might want to refresh the parent form after you finish the action on the dialog or drop dialog form. However, not every dialog form requires that you update the calling form. Typically, you refresh the parent form when the information that you provide in the dialog form appears on that form.

To refresh a parent form,you must write your code in Child form by Override method CloseOk and write the below code.

public void closeOk()
    FormRun formRun;
    // Get an instance of the calling form.
    formRun = element.args().caller();
    // If the caller is a form, refresh that form.

100% working : Fatal exception performing AXRDCE transformation step. The report cannot be rendered. Please contact your system administrator.

Hello Guys,

Today I came with new issue in AX Report.

Few days back my report was working fine.

But today it showed me something weird information while opening the report.

Fatal exception performing AXRDCE transformation step. The report cannot be rendered. Please contact your system administrator. Continue reading

Could not load file or assembly ‘ModelName.axmodel’ or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. – AX 2012

Hi Guys,

I hope you are doing good.  Today I’m gonna share you very intresting thing,  Don’t scare by looking this title but solution is very simple.

I was trying to install my Model File to new environment. But It throws an error


For this issue solution is very Simple. Continue reading

AX 2012 SSRS Error : There was an error while trying to deserialize parameter

Hi Guys,

Today i have faced with new issue which shows the following message,

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter The InnerException message was 'Element '' contains data from a type that maps to the name ''. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver or add the type corresponding to 'SRSQueryBuilderArgs' to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to DataContractSerializer.'. Please see InnerException for more details.

Really its weird  message, So i tried to restart SSRS Services, after restarted service still the same issue was following. Then i searched in online that any users faced similar issue,  same way i found here.

The reason behind the issue was AOS memory which rises more.

So i have deleted my Temp folder files,

C:\Users\Saad\AppData\Local, Delete the all the AUC and KTI files.

C:\Users\Saad\AppData\Local\Microsoft\Dynamics AX\VSAssemblies,  Delete the AUC  file.

Then Stop and Start the Services.


Well, So what are AUC and KTI files here,

AUC extension: Application Unicode Object Cache file (as from AX 4.0)
This file is created on the client side, and is used to improve performance by caching AX objects. When you are in the situation where an AX client keeps using ‘old code’, or where something works on one client and not on the other, removing the AUC file might be the solution.
You can find this file in the directory C:\Documents and Settings\[USERNAME]\Local Settings\Application Data for xp, or C:\Users\USERNAME\AppData\Local for vista.
More information about object caching on Axaptapedia

KTI extension: Kernel Text Index file
This is the index to the KTD file.

KTD extension: Kernel Text Data file
This file contains system text strings. These are used in the interface of AX and for system messages.

Have a good day 🙂