Announcements
No record found.
Hello all,
I have a texbox on report that contains invoice address and it is displayed on 4 lines. I want this value to be displayed horizontally and in one line.
What property can i change?
I am using d365fo.
Thanks.
Hi Paula,
Can changing Row Height or Column Width will meet your requirement?
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-row-height-or-column-width-report-builder-and-ssrs?view=sql-server-ver15
regards
Replace line breaks (\r\n) with commas or something, to create a string with just a single line. Then use a control wide enough to display the full address.
I would use below function for the value, so that it replaces new line with comma. It will bring everything in address field to one single line.
Replace(First(Fields!CompanyAddress.Value,"mytmptable"),Chr(10),", ")
thank you, it works
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 539 Most Valuable Professional
André Arnaud de Cal... 431 Super User 2026 Season 2
CU-1234529-002 184
