view in dynamics.

Hello,

Can I make a view, that include a calculated column (without making a specific function for that), whether the view is like :

select C, sum(A+B) * D

from MyTable

group by C

A,B,C,D are columns on the database.

MyTable is a table in database.

What is the Dynamic equivalent (with no special method for sum(A+B)*D) ?

Thanks :slight_smile:

i think there is no such method in dynamics AX but you can achieve task… by

write one display method in view and return the calculated value (sum(A+B))

and then assign the method into fieldgroup

now you can use the fieldgroup anywhere…

In AX 2012 you can do it

thats the good info to know…thx volodymyr…

r u now working on AX 2012…

do u have any detailed document about “new in AX 2012”

if yes…post it…

i heard C# is replacing X++…can you just post AX 2012 related posts…

thanks & regards

Axxxapta

About C# - it`s not true.

Read this document http://www.microsoft.com/download/en/details.aspx?id=24227

Well.

I am using Dynamic AX 2009, and I don’t think for the long term the old clients would migrate to Version 2012 [:(]

Hopefully, I find some good solutions for the issue of my thread.

Thanks [:)]

Hi,

Please watch this video on Dynamics AX 2012 Developer tools - http://community.dynamics.com/product/ax/axnontechnical/b/axvideos/archive/2011/07/07/inside-microsoft-dynamics-ax-2012-development-tools.aspx

hi…

in view there is no chance of write methods and calculation … b’coz view doesn;t contain any data…

there is one option , in the particular table… write a method and call it in a field… then bring into view… it would be helpful…

thanks

Sainath Satelli

hi harish i watched those 12 videos they r good…

AIF integration was pretty good… seperate port for service communiction…and no more coding for AIF just need to drag drop…AX2012 will move forward the ERP…

CLR strong integration - .Net developer like me…it was a good news…

there is lot more in AX 2012…

thanks for the link…