1,105,286 Community Members

using vbcrlf in RDLC Report expression

Member Avatar
VIPER5646
Junior Poster
114 posts since Mar 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
TnTinMN
Practically a Master Poster
640 posts since Jun 2012
Reputation Points: 418 [?]
Q&As Helped to Solve: 152 [?]
Skill Endorsements: 16 [?]
 
0
 

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 & "-")

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article