Question about fields in views / queries.

Chrizzz1980Chrizzz1980 Member Posts: 2
edited 2009-03-26 in Dynamics AX
Hey all,

I have a quick question, i am quite new with Dynamics AX so please forgive me for asking this but,
How can i make a field for a view or query which calculates a certain value. for example:
    Field A = 12 Field B = 2 Field C = a+b = 14 <

this is the field i require.

Or to merge 2 seperate field values in to 1.
    Field A = Firstname. Field B = Lastname. Field C = a+b = Firstname Lastname. <

this is the field i require.

I can create the above mentioned examples easy in SQL server, but for some reason Dynamics AX does not see the views i create in SQL server (SQLServer does see the views i create in Dynamics though).

I hope anyone of you is able to help, many thanks in advance,

Kind regards,


Christian

Comments

  • abdelabdel Member Posts: 7
    you can use Display method at differents levels : table, form, datasource, and datamethod propriety of the control to display the value
Sign In or Register to comment.