Solved

Invalid characters in my SSRS report

Posted on 2010-11-23
15
768 Views
Last Modified: 2012-05-10
I am getting "<" and >" being displayed in my report. How can I get rid of these characters?
0
Comment
Question by:g46905
  • 6
  • 4
  • 3
  • +2
15 Comments
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
Can you provide more detail such as a screenshot or what sql is used to retreive these fields?  
0
 

Author Comment

by:g46905
Comment Utility
Below is the field that I am using for the field. Can I use trim functionality and replace the unvalid characters?
Fields!ows_COMMENTS.Value
0
 
LVL 27

Expert Comment

by:planocz
Comment Utility
Is this info that you are retreiving from the sql table from a html or asp page?
0
 

Author Comment

by:g46905
Comment Utility
Genious - I am not sure what you are asking. I am retreiving this information from SQL database and displaying it onto my SSRS report. Can you please elaborate what you are asking. Thanks for your help!

0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
Comment Utility
these symbols are comes from a internet display, either from the in coming data that is being stored in the sql database or isomehow in your report.
You might try this in the visitly hide properties of the comment box....
=IF (Trim(Fields!ows_COMMENTS.Value) = "",True,False)
0
 

Author Comment

by:g46905
Comment Utility
planocz - Unfortunately. that did not work....
0
 

Author Comment

by:g46905
Comment Utility
This is what I see for one of the text fields in the reports.....

<html><body><font color="#000080"><b>Susan <sms>, 5/10/2007: </b></font> Per a message from John today, "the headings will remain as is."</body></html>
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 21

Expert Comment

by:Alfred1
Comment Utility
You can try doing this:

Replace(Replace(Fields!ows_COMMENTS.Value,"&lt;","<"),"&gt;",">")
0
 
LVL 21

Expert Comment

by:Alfred1
Comment Utility
Or, with ampersand and quotes

Replace(Replace(Replace(Replace(Fields!ows_COMMENTS.Value,"&lt;","<"),"&gt;",">"),"&amp;","&"),"quot;","""")
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 500 total points
Comment Utility
Ok try this in your code tab properties box
  Public Function CleanHtml(ByVal theText As String) As String
        theText = System.Text.RegularExpressions.Regex.Replace(theText, "b&gt;|&lt;|html|&gt;|&lt;|body|/body&gt;|gt;|&lt;|lt;|font color=|#[0-9]{1,6}|&quot;|quot;|&amp;|sms&amp;", "")
        theText = System.Text.RegularExpressions.Regex.Replace(theText, "/b&gt;|/font|/+[a-z]{1,4}", "")
        theText = System.Text.RegularExpressions.Regex.Replace(theText, "\.+/", ".")
        Return theText
    End Function

On the report use this type of code in the textbox for each data that you want to change.
=code.CleanHtml(fields!ows_COMMENTS.Value)

Also if I missed a char you can adjust it in the function code.
0
 
LVL 3

Expert Comment

by:GSGDBA
Comment Utility
HI,
If you have < and > signs in your code.
Try to remove them

see the below link what &lt;" and &gt;  means
http://www.velocityreviews.com/forums/t160903-what-are-these-characters-and-lt.html
0
 

Author Comment

by:g46905
Comment Utility
Alfred1 - By using your function above, I am able to convery &lt and &gt to '<' and '>'. Unfortunately, now I see below happening.....any suggestions to get rid of this issue??

<html><body><font
color=&quot;#000080&quot;><b>Lisa Jones &amp;lt;lisa&amp;gt;,5/10/2007: </b></font>message from David today,&amp;quot;the heading will remain as is.&amp;quot;</body></html>

0
 

Author Comment

by:g46905
Comment Utility
planocz: - How can I get to "code tab properties box" ?
0
 
LVL 27

Expert Comment

by:planocz
Comment Utility
should be on the body of the report just right click and view the window then click on the code tab and enter the code
0
 
LVL 21

Expert Comment

by:Alfred1
Comment Utility
Try this one:

Replace(Replace(Replace(Replace(Fields!ows_COMMENTS.Value,"&lt;","<"),"&gt;",">"),"&amp;quot;",""""),"&quot;","""")
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now