Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adyscaife
Starting Member
1 Post |
 Posted - 2008-10-10 : 16:08:34
|
| I have a CRM 4.0 database and am attempting to report on Activities. Activities are essentially Outlook forms like email. One of the fields 'description' is the body of eg an email. In the database this is stored as html (actually xml I think). I would like to render this correctly for display in the report. I am using MS BI Studio Report Designer, and there is no inbuilt option for rendering html as far as I can ascertain. I have spent a long time on the web trying to find a solution to this problem. I did initially think I could use the HtmlDecode Method which appears to be made for the purpose but I cannot see how to call it (I am fairly green with vb.net although I am capable of mustering up a select case, ifs, a for next loop and even the odd array). I then thought I might at least be able to strip out the unwanted characters by using Regex as exemplified here: http://www.4guysfromrolla.com/webtech/073000-1.shtml however, I am unable to use: Imports System.Text.RegularExpressions because Report Designer tells me that 'Import statements must precede any declarations' even though it is at the top of the 'Code' section. I even tried seeing if I could put the statement somewhere else in the xml file for the rdl but there does not appear to be an appropriate home for it. Any suggestions? |
|
|
|
|
|
How can I either display rendered html or remove h