DEVELOPING SSRS REPORT WITH CHART USING RDP CLASS

DEVELOPING SSRS REPORT WITH CHART USING RDP CLASS

Here,

                   We have a wonderful blog for Developing a SSRS report with chart using the Report Data Provider...Follow this blog its easy understandable for ax beginners.

Click Here......

DEVELOPING SSRS REPORT USING AX ENUM PROVIDER

Developing SSRS Report using Ax Enum Provider

Step 1:

Create a Query in AOT.

 

 

Step 2:

Add a datasource(SalesTable) into a Query and Set a Range for particular Enum(SalesStatus).

Step 3:

Now open Visual Studio and create new project.

Step 4:

Similarly add dataset into the report and set the property datasourcetype-->Query , Query-->Our Query Name.

Step 5:

Again add one more dataset and set datasourcetype-->Ax Enum provider , Query-->Our Enum Name(SalesStatus).

 

 

 

Step 6:

Drag and Drop the first dataset into design node.

 

 

 

 

    Finally Deploy the Report into AOT.

 

    We will get the output...

 

 

HOW TO USE THE PAYMENT JOURNAL IN THE AP MODULE

We have a wonderful blog for using payment journal in the accounts payable module in ax 2012 .....
    
 Follow this blog its easy understandable for ax beginners.


Click Here.....

 

ENABLE OR DISABLE THE ROWS IN GRID based On CHECKBOX

STEP 1:

Create a Table with Some Fields.Add all fields into FieldGroup except CheckBox Field.

STEP 2:

Creae a Form and add a table as Datasource.

STEP 3:

Drag and drop the Group and CheckBox Field into Design node.

STEP 4:

Write a code in CheckBox  Control level modified() method:

public boolean modified()
{
    boolean ret;

    EnableDisableRows enableDisableRows11;

    ret = super();

    if(this.value()==boolean::false)
    {
        Group1.enableChilds(true);
    }
    else
    {
        Group1.enableChilds(false);
    }

    return ret;
}

STEP 5:

We can get the output,,

 

 

 

SET BACKGROUND COLOR FOR PARTICULAR RECORD

public void displayOption(Common _record, FormRowDisplayOption _options)
{
    if (_record.(fieldnum(Contributions,Year))=="2011")
    {
     _options.backColor(WinAPI::RGB2int(500,100,255));
    }
    else if(_record.(fieldnum(Contributions,Year))=="2014")
   {
     _options.backColor(WinAPI::RGB2int(101,100,255));
    }

    super(_record, _options);
}


 

BASED ON SALESID GET PRIMARY PHONE NUMBER AND ADDRESS

static void TestJob(Args _args)
{
str a; 
SalesTable salestable;
LogisticsLocation logisticslocation;
LogisticsElectronicAddress logisticsElectronicAddress;
LogisticsPostalAddress logisticsPostalAddress;
select salestable where salestable.salesid=='001731';
select logisticslocation where logisticslocation.ParentLocation ==LogisticsPostalAddress::findRecId(salestable.DeliveryPostalAddress).Location;
info(LogisticsElectronicAddress::findByLocation(logisticslocation.RecId).Description);  
info(LogisticsElectronicAddress::findByLocation(logisticslocation.RecId).Locator);
}

 

BASED ON CUSTOMER GET PRIMARY PHONE NUMBER AND ADDRESS

static void TestJOb(Args _args)
{
CustTable custTable;
DirPartyPostalAddressView  dirPartyPostalAddressView ;
LogisticsEntityLocationView  logisticsEntityLocationView ;
LogisticsLocation logisticsLocation ;
LogisticsElectronicAddress logisticsElectronicAddress;
str aa;
select custTable where custTable.AccountNum=="US-005";
info(custTable.address());
aa=custTable.address();
while  select dirPartyPostalAddressView
{
if(dirPartyPostalAddressView.Address==aa)
{
select logisticsEntityLocationView  where logisticsEntityLocationView.EntityLocation==dirPartyPostalAddressView.RecId;
select logisticsLocation where logisticsLocation.ParentLocation==logisticsEntityLocationView.Location;
select logisticsElectronicAddress where logisticsElectronicAddress.Location==logisticsLocation.RecId;
info(logisticsElectronicAddress.Description);
info(logisticsElectronicAddress.Locator);
}
}

}