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!

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

sql 2000 image fields not working

Status
Not open for further replies.

duckyboyz

Programmer
Mar 28, 2002
57
US
I'm using SQL Server 2000 (stored procedure as the datasource), and CR 8.0

I have a stored procedure that has an image field. I see the signature fields in Crystal (to add to the report). CR allows you to add the image field as a "blob". But when I go to run the report... i get the message "Not Supported". Is there anyway to get the image fields to work using a stored procedure. It works fine if I use tabels instead of a stored procedure. But, there's an issue with processing time. It takes a very long time to produce the report.
 
What type of image is this? .JPG? .GIF? Please advise.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com
 
some are .bmp and jpg's. does that matter.. I'm just curious?
 
I have seen a thread that some types of image files are not supported, but I cannot find anything on this, its jut a vague memory in my head. I am still looking for confirmation of this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top