Crystal Report displaying memo field

We have a RichText Box Control in our web application so users can create SQL Server Text fields (memo/notes) with formatting like Bold, Underline etc.  It works fine.  But when I want to display that field in Crystal Report in V10 (over the web) it does not.  I have tried choosing different format properties for that field from "None" (shows all the tags, to "RTF" (again, shows all the tags) to "HTML" (does not show the tags but does not show the formatting either.

What do I need to do so that the data is displayed with all its original formatting intact?

Thanks,
Disha
DishaKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
I am not ver familiar with a Rich Text box.  Does it send the data out as RTF?

Crystal doesn't support the full family of RTF tags.
http://support.businessobjects.com/library/kbase/articles/c2011504.asp

What viewer are you using on the web?  Some of the Crystal viewers for the web are limited in capability.

mlmcc
0
DishaKAuthor Commented:
The article referenced did say that it is supposed to display bold and underline tags (at least correctly) but - in my CR display it shows ZERO formatting (including BOLD)!

Thanks,
Disha
0
DishaKAuthor Commented:
FYI, the tags from Rich Text Box are coming out as <b> for bold is that ok for Crystal Report to display bold formatting??

It seems like - as long as I chose RTF for the field property it should display the formatting for CR 8 and after. Why is it not working for me?

Thanks,
Disha
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

mlmccCommented:
From my article
\b · bold (b0 is used to switch off bold)

Where is the rich text box?  What are the properties set?  It may not store in "true" RTF format.

mlmcc
0
DishaKAuthor Commented:
Well, I looked at the Rich Text Box (in .Net application) - I think the tags are HTML (<b>,</b> etc.) I looked at its properties and could not find a place to set it to RTF.  However, shouldn't I be able to display formatting if I chose "HTML" in CR instead of "RTF"?  When I choose "HTML" it at least does not display the tags but then it strips out ALL formatting!

If I can find a place for the Rich TextBox to save in RTF I will do that and try.  In the meanwhile, if you know about the "HTML" property in CR then please let me know.

Thank you,
Disha
0
mlmccCommented:
I don't know much about the HTML property.  It should work but the file might have to start as an HTML page which I doubt this does.

Is this field something that is stored in the database?

Could a short application be written to translate to appropriate format?

mlmcc
0
DishaKAuthor Commented:
Yes, this is stored in SQL Server with data type - Text.  I am sure something could be written to translate to an appropriate format.  To see that I would need some time I do not have.  This application is rolling out in less than a week and I have some other edges I am smoothing out too.

If you have any examples, I would appreciate the help.

Thanks,
Disha
0
mlmccCommented:
Can you tell me what the formatting "codes" are?  I have access to VB6 is that rich text box the same?

mlmcc
0
DishaKAuthor Commented:
I do not this it is the same.  This is a third party tool used mostly for web applications, I believe.  The intellisences on the property in code showed the following properties.  But they are not getting me anywhere as even if I use .text and specify HTML in CR it still displays with all the HTML tags.  


.text (HTML)
.textPlain(HTML tags removed)
.textRaw(similar to HTML)
.textXHTML(Closeley resembles XHTML)

Anyways, thank you for trying.  Maybe this is something I will spend more time on after the application rolls out and for now find a workaround.  

Thank you, again, for trying.

-Disha

0
mlmccCommented:
A short applicatiion or perhaps a Crystal formula could be written to convert the field to proper RTF format.  I would need to know the codes that aren't being interpreted.

mlmcc
0
mlmccCommented:
Found this when searching for another problem.  It is for CR9 but it may apply

http://support.businessobjects.com/library/kbase/articles/c2012136.asp

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DishaKAuthor Commented:
You definitely got me in the right direction.  Although the reference was for V9 - it got me thinking maybe I need to check if there are any updates for V10 - and surely enough there was.

Then - I tried to display in RTF - but that still did not work.  But if you will see two threads back that the particulat Rich Text Box had only HTML formats and XHTML formats (other than Plain Text.)  So, I changed the CR display format to HTML and voila it worked!!  FYI, I tried HTML before and it did not work.

All is well.  Thank you, again, for heading me in the right direction.

Thank you,
Disha
0
mlmccCommented:
Glad i could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.