SQL Reporting Services Text Field in Report Builder

(0) Share

Report

Posted on by john.ellis

3,510

Hi:

When I run a custom Purchase Order report in SSRS Report Builder, I get an error pointing to a text field that I created containing an expression (Expr) that houses a colon.

This is shown below.

How do I change this formula to prevent the error from generating and to allow for the colon to display?

Thanks!

=”PLEASE SEND INVOICE TO THE FOLLOWING ADDRESS"&":"
&Fields!CompanyAddress1.Value

John

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I did the same test but did not get an error.

="PLEASE SEND INVOICE TO THE FOLLOWING ADDRESS"&":"&Fields!CustomerAddress1.Value

Was this reply helpful? Yes No