Microsoft KB Archive/944230

= Account Summary Report Renders HTML code instead of text for select characters after installing KB 925500 =

Article ID: 944230

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-



Source: Microsoft Support



RAPID PUBLISHING
RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.



Action
You run the Account Summary Report for an Account that contains an email body with Rich Text Characters such as: ‘ (Apostrophe) “ (Left Quote) ” (Right Quote) … (Three dot series) – (Dash, not hyphen)



Result
The email body includes HTML code:

&#8216; (Apostrophe) &#8220; (Left Quote) &#8221; (Right Quote) &#8230; (Three dot series) &#8211; (Dash, not hyphen)



Cause
The report file uses XML coding that incorrectly handles or converts HTML symbols. Known HTML character codes are replaced on the fly when the report is rendered. The report does not take many HTML characters into account.



Resolution
Open CRM with a user account that has the permission to Manage Reports, download the report and edit it to replace the HTML code with characters.

1. Download the report from CRM using the following steps:

Click Workplace, click Reports, click the Report to edit, click More Actions, and then click Download Report.

2. Edit the report XML to include more HTML characters to replace. The report XML can be edited using Notepad or any other XML editing program.

This text can be appended to line 1843 of the Account Summary Sub-Report RDL XML (if using Notepad you may have to turn off Word Wrap) right below the following lines:

strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;trade;&quot;,&quot;(tm)&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b2693 strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;frasl;&quot;,&quot;/&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b2693 strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;amp;&quot;,&quot;&amp;&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b2693

3. Save the .RDL file and upload the report back into CRM with a CRM user that has the permission to Manage Reports.

Upload the report into CRM using the following steps:

Click Workplace, click Reports, click Action, and then click New. Name the report and specify its location and custom details, and then click Save.



MoreInformation
We require symbols of valid ASCII characters.

The replace does not allow the double quote code so you have to use two individual tick marks.

Here is another example where we are replacing the &amp; with an & sign.

In the Replace strText the first set of quotes is what are looking for and the second set is what we are replacing it with. In this example &amp;#8211; becomes &#8211;. Notice that all that was done is the &amp; was replaced with an & symbol.

strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;#8211;&quot;,&quot;&#8211;&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b3753 strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;#8216;&quot;,&quot;&#8216;&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b3753 strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;#8220;&quot;,&quot;&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b3753 strText = System.Text.RegularExpressions.Regex.Replace(strText, &quot;&amp;#8221;&quot;,&quot;&quot;, System.Text.RegularExpressions.RegexOptions.IgnoreCase)' b3753



DISCLAIMER
MICROSOFT CORPORATION AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, RELIABILITY, OR ACCURACY OF THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN. ALL SUCH INFORMATION AND RELATED GRAPHICS ARE PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, WORKMANLIKE EFFORT, TITLE AND NON-INFRINGEMENT. YOU SPECIFICALLY AGREE THAT IN NO EVENT SHALL MICROSOFT AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF OR INABILITY TO USE THE INFORMATION AND RELATED GRAPHICS CONTAINED HEREIN, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF MICROSOFT OR ANY OF ITS SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES.

Keywords: kbnomt kbrapidpub kbmbsmigrate kbmbsreports KB944230

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.