Link to home
Avatar of sfuk
sfukFlag for United States of America

asked on

Oracle CLOB datatype in SSRS report

Dear Experts,

I need to display CLOB column in SSRS report, the length of which is more than 32K. The column contains HTML tags as well as formatted text. When the HTML tags are striped out, the output loses its formatting, including defined paragraphs and font differences (except capitals and lowercases).
Could you please help me to resolve this issue?  

Thank you in advance,
sfslku
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

there are few new data types which can handle long objects.. did you explore those options? check the below site for details..

http://sqlmag.com/t-sql/dont-be-afraid-blobs-and-clobs

Responding to a neglected question alert.  Not an expert from SQL Server background. Till some one arrives see if this helps
>> I need to display CLOB column in SSRS report, the length of which is more than 32K.

Just curious on what kind of data greater than 32K you are trying to show in SSRS report. If you are going to show an 32K data in your report for assuming 10 records, it would be difficult to view it in the Report.
So, my first suggestion would be to limit and show only useful data in the Report and not just the entire data present in the html tags.

>> The column contains HTML tags as well as formatted text. When the HTML tags are striped out, the output loses its formatting, including defined paragraphs and font differences (except capitals and lowercases).

Yes, by default SSRS will not render HTML values unless you define or instruct it to show HTML tags in the report.
And please note that SSRS has a limitation on rendering HTML tags and hence it will render only limited HTML tags as mentioned in the below MSDN link..
http://msdn.microsoft.com/en-us/library/ff519562%28v=sql.105%29.aspx

And you need to define the Placeholder properties to ensure the HTML tags are rendered properly.
For the CLOB column displaying in SSRS, Right click the Field and choose PlaceHolder properties -> General -> For Markup type choose "HTML-Interpret HTML tags as styles".
Also note that SSRS cannot render or interpret all HTML tags and only the tags listed in the above MSDN link only..
Avatar of sfuk

ASKER

Thank you for the replies.
Unfortunately,  change of the datatype is not an option until CLOB may be converted into it while a report is generating.
The comments that bigger than 32K are some reviews. They look fine in SSRS if entered as copy-past from Notepad.
But when MS Word is used or the data is entered straight from a web app then it is a problem.
Avatar of sfuk

ASKER

For more details:
Below is example of the output that I need to format.  Is there anyway to remove these XML tags and keep the rest of the text as it is? Thanks again.

1. The offseason is all but over – not in terms of duration, unfortunately, but based on the moves teams are going to make in order to improve their roster.<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />
2. To see today’s results based solely on the draft, click here.<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />
3.  Movies and More:<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-com:office:office" />
     In the 2008 movie "Iron Man," the main character becomes a superhero after building a suit of armor with an      
     exoskeleton that gives him incredible strength.<?xml:namespace prefix = "o" ns = "urn:schemas-microsoft-
     com:office:office" />
Hi sfuk,

As mentioned earlier, xml:namespace is not supported by SSRS and hence those HTML data will not get displayed properly.
ASKER CERTIFIED SOLUTION
Avatar of sfuk
sfuk
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Thanks for the update, sfuk..
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.