Tuesday 31 March 2020

squish up the address using expressions in ssrs

=Replace(First(Fields!CompanyAddress.Value, "SalesInvoiceHeaderFooterDS")+"  Phone:  "+First(Fields!CompanyPhone.Value, "SalesInvoiceHeaderFooterDS"), Chr(10), ", ")