The SQL database has issued an error. SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.

Make sure to update the following EDT properties of Name and Txt fields on the table.
Name —> DirPartyName

Txt — > ItemFreeTxt

Advertisements

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’

    =RunningValue(Fields!Outstanding.Value,SUM,”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

http://blog.365freelance.com/year-ahead-for-microsoft-dynamics-ax/

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()
{
    #Task
    FormRun formRun;
    
    super();
    
    // Get an instance of the calling form.
    formRun = element.args().caller();
    
    // If the caller is a form, refresh that form.
    if(formRun)
    {
        formRun.task(#taskF5);
    }
}

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