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
*This post is locked for comments