Member Avatar for VIPER5646

Hi
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

  • 2 Contributors
  • 1 Reply
  • 135 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by TnTinMN
Member Avatar for TnTinMN

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

=Fields!ColumnC.Value

Use the Replace function to replace the comma,

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.