Announcements
No record found.
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,
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;
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
Thank you,but it displays in multiple vertically split format,How can i change it into horizontal single sentence
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);
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sagar Suman 2 Super User 2026 Season 1
Alexey Lekanov 2
Pratik Bhosle 2
