473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can we use BLOB fields (that store images) in Crystal Report ?

I'm developing with ASP.NET, VS.NET 2003.
Using Crystal Report for VS.NET
DataBase: Oracle 10g

I store a BLOB field in a table. This field store images, like jpg
files.

The Stored Procedure that I use to fill the report is:

OPEN MyCursor FOR
SELECT MyId , MyImg
FROM MyTable

MyImg is BLOB field

However, when I try to use the stored procedure in Crystal Report at
design mode, any field can be displayed and then drag and drop to the
report, but MyImg is not possible.

There is an error message:

Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for Oracle
Description: Data type is not supported

I'm afraid that is not so easy for me to change DB connector drivers.

My question is:
- Is it possible to use BLOB fields in Cyrstal Reports?
- Or should I convert them previously to something, so they can be
displayed in Crystal Report at desing mode ?
- If I should change DB connector drivers, which one should I use and
from where should I download it and then install it in my Web Server?

Thank you very much!

Sep 21 '06 #1
0 5025

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: NotGiven | last post by:
I am researching the best place to put pictures. I have heard form both sides and I'd like to know why one is better than the other. Many thanks!
1
by: Stephan | last post by:
Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal...
0
by: Winston | last post by:
Hi, I am trying to display an image using BLOB in crystal reports. The Reports BLOLB fields are generated using an XML Schema as follows: .... <xs:element name="bSignature"> <xs:complexType>...
0
by: Jeff | last post by:
Help!!! The bitmap I am trying to display in a sample Crystal Report is coming up with much less quality than the original bitmap. I have a 300x300 dpi bitmap file that I want to insert at run...
0
by: Skiran | last post by:
Hi to everybody, I am handling a large-scale project of MIS (Marketing information System). I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool. 1)...
0
by: amiga500 | last post by:
Hello, I am developing a crystal report called Expense Report (I am not an expert Crystal Report designer) if someone could help me in this problem I would be greatly appreciate it. The report...
55
ADezii
by: ADezii | last post by:
Of all the questions asked here at TheScripts, the one which appears with the most frequency relates to the storing of Graphic Images within Access. There are basically three techniques available to...
2
by: ROBUENO | last post by:
I NEED A WAY TO CONVERTER IN THE BASE DB2 DATAS TYPE (BLOB) INTO (VARCHAR/LONG VARCHAR) TO STORE IN A VIEW. I WORK WITH THE REPORT GENERATOR CRYSTAL REPORT AND INSIDE OF THE TOOL ENVIRONMENT I...
1
by: gsauns | last post by:
I store images in my SQL 2005 database in a varbinary(max) field. I want to display them in a Crystal Report. Within Crystal Reports, when I put the field on the page and preview the report, it...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.