Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have a text column in my database storing HTML but crystal won't display it

Status
Not open for further replies.
ifthenelsenull

ifthenelsenull

Technical User
Nov 17, 2011
31
US
cr XI, SQL 2008. This is a vendor database so I can't change how they store things.

When I display this field in crystal it's blank. I set it to can grow and changed the paragraph text interpretation options to HTML Text.

The data looks like
HTML: 
<HTML>
<HEAD>
<style type="text/css">BODY,TD,TH,BUTTON,INPUT,SELECT,TEXTAREA{FONT-FAMILY: Arial,Helvetica; COLOR: black; FONT-SIZE: 10pt;} P,DIV,UL,OL,BLOCKQUOTE{MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px;} BODY{MARGIN: 5px;} </style>

</HEAD>
<BODY> <p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font style="FONT-SIZE: 18pt" color="#0000cd">Lots of informative text.</font></p> 
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font style="FONT-SIZE: 18pt" color="#0000cd">&nbsp;</font></p> <p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">
</p>
</BODY>
</HTML>

I need to figure out how to display this is crystal in a way that will also work as it's converted to PDF. I appreciate any help you can provide.
 
Sort by date Sort by votes
What is the max length of the data in this field ? My question is about the actual data not about the format of the field.

Viewer and Scheduler for Crystal reports and SSRS.
 
Upvote 0 Downvote
You can try to create a formula like this one:
Left(CStr({FieldName}),3000)
and use it on your report instead of the field.

Viewer and Scheduler for Crystal reports and SSRS.
 
Upvote 0 Downvote
I figured it out. It turned out that the text field in the DB became a memo field in crystal. I unfortunately had the field in the group section and that doesn't work. Once I dropped it into the details it functioned as expected. Thanks for your help.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
426
Kennymc
Kennymc
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
309
Ivan Kok
Ivan Kok
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
321
dgillz
dgillz
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
400
hilfy
hilfy
dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
276
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top