HtML TEXT Box Control

[Farrukh]

We are using HtmlTextbox for reporting english and arabic data because exporting to word file doesn't work fine with database column directly .Now porblem in htmltextbox is, if data have wild character like  (&, /,$ , ; ) it gives error "An error has accured while processing HtmlTextBox".Kindly gives us solution as soon as possible thanks.

[Steve]

Hi Farrukh,

According to the HTML specification (and the general XML specification) the "&", "<" and ">" characters are considered special (markup delimiters), so they need to be encoded in order to be treated as regular text. For example the "&" character can be escaped with the "&amp;" entity. More information on the subject you can find in this w3.org article.

Kind regards,
Steve
the Telerik team

[Bob]

I have been having some issues with the "&" and the htmlTextBox. Until now I have been able to escape it with the "&amp;" by executing a "Replace("&",""&amp;") in the SQL code for the SqlDataSource SelectCommand. We now have to attach the same command to an Access 2007 database. Access does not support the remote execution of the "Replace" command so I can't escape it using SQL. How can I escape the command using the "Replace" command in the report expression?

The statement below does not work.

design view:
{Replace(Fields.CurrentAssee,"&","&amp;")}{Fields.incareOf}
{Fields.streetAddress}
{Fields.City}, {Fields.state}
{Fields.zip}

html View
{Replace(Fields.CurrentAssee,"&amp;","&amp;amp;")}{Fields.incareOf}<br />{Fields.streetAddress}<br />{Fields.City},&nbsp;{Fields.state} {Fields.zip}

Thanks,

bobn :>)

[Stef]

Hi Bob,

At our side using the Replace Text function in the Html view of the HtmlTextBox works as expected:

the tested expression:
{Replace("test&test","&","&")}

You can also use a custom function to escape special characters.

If you need further help, feel free to open a support ticket and send us a sample report with your settings and test data to run it.

Regards,
Stef
Telerik

 

 

[Bob]

I see that you are referencing the HtmlTextbox from the "Design View". There is no need to escape "Test & Test" as the input as it translates the value as "Test &amp; Test" in the html view. Try data binding the value "Test & Test" and passing it into the textbox and then tell me how it works out. As far as custom functions go, I was never able to use a custom function, it reports and error "The expression contains undefined function call Replace().
{TAXI.Classes.ReportFunctions.Replace(Fields.CurrentAssee,"&", "&amp;")}{Fields.incareOf}
{Fields.streetAddress}
{Fields.City}, {Fields.state}
{Fields.zip}

Thanks, Bobn :>)

[Stef]

Hello,

You can find attached a sample report definition, illustrating our test to escape the & symbol in a text coming from the data.

Regards,
Stef
Telerik