Address in single sentence - AX 2012 SSRS reports

Chaitanya Golla

17,225

Like ( 0 )

Report

Hi,

There is often common requirement to display address either customer/vendor/company in a single statement in ax 2012 ssrs report. strLine function is one that helps us to achieve this and follow below steps.

1. Set the value for the width property(under Position/size) of the textbox equal to tablix.

2. In the insert* prefix method of DataProvider, include the following code while filling up temporary table. Here, we used address of the company.

LogisticsAddressing address; // Declare variable
address = companyInfo.postalAddress().Address;

// Display single if address format has 4 lines. If it has more lines then add extra strLine function by incrementing the number
TmpTable.CompanyAddress = strLine(address.Address, 1) + strLine(address.Address, 2) + strLine(address.Address, 3)
 + strLine(address.Address, 4);

Regards,
Chaitanya Golla