Posts

Showing posts from April, 2012

System Table as a Temp Table

How to use a system table as a Temporary Table  We can use a system table as a temp table in our coding just try the following code....
static void CopyPersistedTableToTemp(Args _args) {     CustTable custTable;     CustTable custTmpLedger;     ;     custTmpLedger.setTmp();     custTable.recordLevelSecurity(true);
    while select custTable where custTable.City == 'Toronto'     {         custTmpLedger.data(custTable.data());         custTmpLedger.doInsert();      } }


By using this code you can use a system table as a temp table and the good thing in this , this didnt disturb your main table configuration and data in that table. it just create a object of a table and use this object as a temporary.

SSRS Tutorial Video

Hi Friends,
Today I am sharing a Video for SSRS reporting Services, to batter understanding just try to do at your end also you have following s/w for this,
1. Visual Studio with reporting extensions 2. SQL server 2008/2005
3. Dynamics AX

LookUp On forms

hi guys,
Here i am sharing a method to how to use a lookup In FROM Control....
so just try the following method in your code..


public void lookup()
{

    Query                   query = new Query();
    QueryBuildDataSource    qbds,qbds1;  
    QuerybuildRange         QuerybuildRange,QuerybuildRange1,QuerybuildRange2;
    QuerybuildLink          QuerybuildLink;
    SysTableLookup          sysTableLookup;

    ;

    sysTableLookup = SysTableLookup::newParameters(tablenum(UB_ResourceRequest1), this);

    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ResourceRequestNo), true);
    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,RRStatus), true);
    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ApprovedNumber),true);
    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,AllocatedNumber),true);
    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,DateOfRequirement),true);
    sysTableLookup.addLookupfield(fieldnum(ResourceRequest1,ApprovalStatus),true);

    qbds = qu…

RunBase frameWork In X++

Image
RunBase framework

Whenever you write a class that typically asks a user for input and then starts a process based on that input you use the RunBase framework as most of the typical methods needed for such a Job is already implemented in the RunBase class. This means that using the RunBase framework is done by extending RunBase either by directly extending RunBase or by extending a class that extends RunBase. Some of the features implemented in the RunBase framework are the following:
• Run: The main flow of the operation • Dialog: Prompting the user for input and storing that input • Batch execution: Schedule the Job for later execution • Query: Used to select data • Progress bar: Shows the progress of a task • Pack/unpack with versioning: Remember variable values until the next time the task is executed






-Harry

Mehods in AX

Hi guys,

Here i  want to share a link for all basic methods which we can use i n our Form s and reports Customization....
here u find all predefined methods for axapta 2009 as well as 2012
Click here For Methods in AX

-Harry

How To Create Forms in Enterprise Portal

Image
ABSTRACT:-This article demonstrates how to create basic forms in Enterprise Portal. Create a DataSet

1. Open Microsoft Dynamics AX.
2. Open the AOT.
3. Right-click on the Data Sets node and choose New Data Set.
4. Right-click on the newly added data set and choose Properties.
5. In the property sheet rename the new Data Set to SampleCustomers.
6. Expand SampleCustomers.
7. Right-click the Data Sources node and choose New Data Source.
8. Right-click the new Data Source and choose Properties.
9. In the property sheet set the Table property to CustTable.
10. In the property sheet set the Name property to CustTable.
11. In the property sheet set the InsertIfEmpty property to No.

Create a Web Project1. Open Microsoft Visual Studio 2008.
2. Under the File menu choose New and then Web Site.
3. Choose Visual C# as the Language – note that only C# is supported.
4. Choose Dynamics AX Web Project as the template.
5. Enter SampleBasicForm as the project name.
6. Click OK when finished.
Create a User Control and Ad…