Skip to main content

We have a report that has text box with nothing but information on where to call, or order items online. 

The text box reads: Questions? Call 123-456-7890 | (yes that is a pipe symbol included) Order Online at www.company.com. For some reason it is throwing an error. I have tried using single and double quotes in various places but still no joy.

 

@wmatthews1877 I get the same error if I try to validate the expression, but using the characters in the report works fine with my testing on Version 2023 R1. Can you ignore the expression validation and try running the report with the characters?

 


There is another error “Cannot interpret the token “?” at position 11.” when the report is run.


I found the answer by trial and error. For anyone else that would need to include a question mark inside a text box, the formula is  ='Questions?  ' + 'Call 1-123-456-7899 | Order Online www.mycompany.com'. Even the pipe | symbol was accepted. Thank you to all who responded.


Sorry, I forgot to add one caveat; the text line is in the groupHeaderSection1, and not in the detail section.


Thank you for sharing your solution with the community @wmatthews1877!


Reply