Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-18 : 07:48:09
|
| Syed Abid Ali writes "Dear Sir/ MadamI am using VB6, Sql server 2000 and Crystal Report 8.0 and I am facing a problem which is that i want to save chemical formulas Like H2O, H2So4 which have some super and sub script characters so I am taking for this a rich text board wand make formula in MS Word then copy and paste into it. Then save in SQL server as varchar field, which is, saves as code (means not Human language) when i retrieve it into same form it was display fine but when I put into Crystal report and see view of it. It will display "H" as same font size, "2" which is subscript display in one step small font and then "O" also in same if their is another Superscript or Sub Script then next characters make more small.Please consider my problem seriously, me reply me soon. I am look forward to you.Thank You.S. Abid Ali" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-18 : 07:53:58
|
| The only suggestion I can make is to format the formula in Rich-Text Format (RTF) or HTML, and pray that Crystal has controls that can interpret and display them properly (I'm pretty sure it can). RTF and HTML are nothing but text, so you won't lose formatting instructions from Word's binary hash. |
 |
|
|
|
|
|
Super and Subscript Bug...