Start New Discussion within our Software Development Community

I have a column (ColumnC) in an access query which extracts the notes from column A and ColumnB and seperates them with a comma.
This is the expressoin I use in access (Note: [RecheckNote] & IIf(Not IsNull([RecheckNote]) And Not IsNull([CTNote]),",","") & [CTNote] )

What I would like is to write an Expression in RDLC report that everytime it encounters a comma it would do a line return and Put "-" after the line return.
Thanks in advance

Presumably you have a table in the report and the cell expression is currently something like:


Use the Replace function to replace the comma,

=Replace(Fields!ColumnC.Value, ",", VBCrLf & "-")

This article has been dead for over six months. Start a new discussion instead.