In a SSRS Matrix cell I want to be able to have a line break between each output given.
I have the following code in my MS SQL Server Stored Procedure which I then point my SSRS report to
SELECT Customer, Hostname, (QName + QHostname + Qtag + QSerial + QCategory + QType + QItem + QManu + QModel + QVersion) AS AdditionalInfo1
For SSRS, you want to use Chr(10), not Chr(13). I've used this in expressions and as a Join delimiter argument and it produced the desired effect: line breaks within the textbox.
Below is an expression that will return an empty string if the field value (QHostName) is null, or the value preceded by a newline if it is not.
IIF(ISNOTHING(Fields!QHostname.Value),"", vbCrLf + Fields!IQHostname.Value)