• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 906
  • Last Modified:

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
0
DishaK
Asked:
DishaK
  • 7
  • 6
1 Solution
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now