Hi all,
I need to display my company address in footer in single sentence ,in SSRS report,How can i do like that?
*This post is locked for comments
Hi,
Set the value for the width property(under Position/size) of the textbox(in the footer) equal to your tablix.
While filling your temporary table, use the following code:
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);
Thank you,but it displays in multiple vertically split format,How can i change it into horizontal single sentence
Hi,
You can pass it e.g. in a field in the report tmp table, and display it on the report layout. If it is an already existing one, you can refer to this article.
Regards,
István
Hi,
If you have companyaddress field in your temporary table, then add a footer to the report and add a textbox in the footer. Use this expression for the newly created text box: =First(Fields!CompanyAddress.Value). If you don't have this field, then create a field of type LogisticsAddressing on temporary table and use this code to populate TmpTable.CompanyAddress = companyInfo.postalAddress().Address;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156