Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
