Sunday, August 12, 2007

Alternate of Formula Fields of Crystal reports in Dynamics AX Reports

Hello guyz,I am writing frequently nowadays. It means that i am doing lots of work. I was to prepare some report for some of my client. Generally back in the days of .net and crystal report, the functionality which was required to be implemented could easily be fulfilled by Formula Fields. But to my astonishment, there are no formula fields in Dynamics AX reports.

There is an alternative to it. AX allows you to have programmable sections in the report. In these programmable section, you can insert different control. So i inserted on control having String Type Data.

Set the AutoDeclaration property of this control to TRUE. In this way you can programmably access this control.Now override executeSection() method of this programmable section and write your programmable logic in this method.