Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Friday, July 14, 2006

Create a new Datasource and link it through code!

Have you ever wanted, through code, to add a new datasource to an already existing one? Well below is some code that will show you how:

QBSInvent = QBSSum.addDataSource(TableNum(InventItemLocation),"InventItemLocation");
QBSInvent.addLink(fieldnum(InventSum,ItemId),fieldnum(InventItemLocation,ItemId));
QBSInvent.addLink(fieldnum(InventSum,inventDimId),fieldnum(InventItemLocation,inventDimId));
QBSInvent.addRange(FieldNum(InventItemLocation,WhsABC)).value(int2str(gWhsABC));

Basically in this code I create a new Query Database Source, and add it to an already existing one. Then I take and addlink methods to link the two datasources, then the range, and bang! My new datasource now works and is part of the lookup for the given query that may be running for a report, or anything. This is very useful code for working with Dialog's, etc. And you want to add ranges based on different selection types that the user makes.

Check back soon as I will post about integration with Ax 3.0 and what to look for in 4.0!

Find a job at: www.DynamicsAXJobs.com

0 Comments:

Post a Comment

<< Home


Copyright 2005-2011, J. Brandon George - All rights Reserved