Wednesday, December 30, 2009

Yet another AX 2009 development book

This book is in the cookbook style, where you are advised on how to solve certain tasks of Dynamics AX development: Microsoft Dynamics AX 2009 Development Cookbook

Wednesday, December 23, 2009

Identifying the current application environment

There is a ton of ways you can identify what application you are running, when running an application from a set of similar environments like "Development", "Test", "Staging" and so on.

So here's a new suggestion on how you can setup identification like this, without any custom coding in the application: Add the identifier to your Role Center.

Here's how to add the text:
  • Open your Role Center
  • Click Personalize this Page
  • Click Add a Web Part in the zone where you want the identifier to appear
  • Add the Content Editor Web Part
  • Click the "open the tool pane" link that appears in the web part
  • Click Rich Text Editor
  • Add and format a text. For example "You are in the TEST application"
  • Click Save
  • Open the Appearance node
  • Enter a meaningfull title to replace "Content Editor Web Part"
  • Click OK
  • Click Exit Edit Mode (to the upper right)

Monday, December 21, 2009

Suppress report scaling messages

If you want to suppress the infolog message "Report is scaled to xx percent to fit page", you can do it by adding the following statement to your report code, in for example the init method:

Sunday, December 20, 2009

Data Set lookups on Enterprise Portal (EP)

I just spent a complete day trying to make a simple lookup for EP. The lookup was intended to be a lookup on EmplTable, with the ability of filtering on the name of the employees, and it is supposed to return the employee id.

The query behind is built on EmplTable with an inner join to DirPartyTable to get the name.

The easy solution would have been to make a lookup based on a new Data Set, but in trying that I came across two odd limitations in this type of lookup:

  1. You’ll only be able to sort the lookup on the field you want return.
  2. The filter will only show tables from the outer table. The joined tables doesn’t show up.

I find these two facts limiting the usability of the lookup in such degree, that I can’t imagine the lookup was designed this way and I’m assuming it is my own limited skills preventing me from getting the lookup to work like I imagined.

I actually found one other data set (WorkflowUserListLookup), aimed at driving a lookup in standard, built after same model, but it doesn’t seem to be used from the EP application...

Do you have any experience with Data Set lookup based on joined tables and do you know if this lookup could be achieved with a Data Set lookup? Please comment.

B.t.w. I solved the lookup by developing a new user control with a temporary table to drive the lookup.