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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Anyway to use formula on Blob Field?

Status
Not open for further replies.
smedvid

smedvid

MIS
May 28, 1999
1,228
US
I have a report with a VarChar(2000) field. The user needs to export this report to Excel. Appearently there is a limit of 255 Characters on the export to Excel from Crystal. My solution was to have a query with SUBSTR(F,1,254) as F1, SUBSTR(F,255,254) as F2,...etc.

I was able to create a Query definition, but the Web Based report appears to need raw SQL. And, I was able to get the report to run via CRW. But when I handed to report off to the web team, the report does not run via the web app.

Any ideas are appreciated... tia, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

Chester County, PA Residents
Please Show Your Support...
 
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
466
TPG_IT
T
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
672
dgillz
dgillz
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
203
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
246
socalvelo
socalvelo
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
329
john432
john432

Part and Inventory Search

Sponsor

Back
Top