You’re offline. This is a read only version of the page.
110
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);
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.
#1
André Arnaud de Cal...
291,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (