I have a Windows application which uses the Telerik Reporting for displaying reports.
- The Windows application has many comment fields (contains rich text - data copied from Word, Exel, PDF).
- The comments data could contain Chinese, European, Indian etc alphabets.
- Styles like Font change, Bold, italics, highlights can be applied to the comment fields
4. The data is stored in the Access Database
Issues are as follows:
When these comment fields are to be displayed in the Reports--> HTMLTextBox, (since richtext htmlTextbox is used) error occurs as the HtmlTextBox is unable to identify the html tags (mostly generated by Word, Excel and Pdf).
Steps Followed
- Place the HTMLTextbox controls in the detail section of the Reports
- HTMLTextBox --> Properties --> Value --> Bind the Comment field from the database to the control
- Properties -- > Change the Font to Arial Unicode MS to accept other language characters
- Build report.
- This report is called from the Windows Application.
Please find attached a sample HTML generated from the Word and the error occured.
Please note..
When these Html generated tags is directly copied into the Design View of Editor properties of the [HTMLTextBox--> Value ]
and switch back to HTML mode, they are displayed fine when you Preview from the Report project (like harcoding) . I have noticed that the Design view of the Editor Properties validates the HTML to proper Html tags. But the HTMLTextBox as such fails to do the same.
The reports needed for the application is dynamic data.
Please need a solution to this..
Thanks
Shalini
Sample HTML
<SPAN FONT-SIZE: 16px""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size: 10.0pt; mso-bidi-font-family: Arial;
mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><STRONG><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS';
mso-bidi-font-size: 10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信有限公司</SPAN><SPAN COLOR: black;
FONT-FAMILY: Arial; mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(CHEERSIN LIMITED)<?xml:namespace prefix = o ns =
""urn:schemas-microsoft-com:office:office"" /><o:p></o:p></SPAN></STRONG></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size:
10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信工程有限公司</SPAN><SPAN COLOR: black; FONT-FAMILY: Arial;
mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(WISE FAITH ENGINEERING LIMITED)<o:p></o:p></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size:
10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信企業有限公司</SPAN><SPAN COLOR: black; FONT-FAMILY: Arial;
mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(CHEER VISION ENTERPRISES LIMITED)<o:p></o:p></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><EM><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS';
mso-bidi-font-size: 10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信行有限公司</SPAN><SPAN COLOR: black;
FONT-FAMILY: Arial; mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(FAITH KIND COMPANY LIMITED)<o:p></o:p></SPAN></EM></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN COLOR: #ff8040; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size: 10.0pt;
mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial""><SPAN lang=DE FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size: 10.0pt;
mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信技研有限公司</SPAN><SPAN FONT-FAMILY: Arial; mso-bidi-font-family:
Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(NETECIS ENGINEERING LIMITED)</SPAN></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size:
10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信技術有限公司</SPAN><SPAN COLOR: black; FONT-FAMILY: Arial;
mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(SMARTCOMM TECHNOLOGIES CO., LIMITED)<o:p></o:p></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size:
10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信科技有限公司</SPAN><SPAN COLOR: black; FONT-FAMILY: Arial;
mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(WISE HONOUR TECHNOLOGIES LIMITED)<o:p></o:p></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""><SPAN lang=DE COLOR: black; FONT-FAMILY: 'Arial Unicode MS'; mso-bidi-font-size:
10.0pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial"">智信科技香港有限公司</SPAN><SPAN COLOR: black; FONT-FAMILY:
Arial; mso-bidi-font-family: Arial; mso-fareast-font-family: 'Arial Unicode MS'"">(WISE MICROTEK CO., LIMITED)<o:p></o:p></SPAN></P>
<P MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify""></SPAN></SPAN></P>