sql server 2000 image fields not working

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.
Mike JohnsonBusiness Inteligence DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ebolekCommented:
You can create a dataset and insert the stored procedure as the datatable of the dataset and then you can create your report woth thye datasource as that dataset. Place the blob field into your reprt

When the dataset is filled, the blob field is going to show your image. This is how i display my images in crystal 10. Hopefully it is the same in 8.5 too.

Regards
Emre
0
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
I don't understand what you mean by a "datatable"?  Are you using SQL Server 2000? Perhaps.. if you had a copy of the script you're using I could get a better understanding.
0
ebolekCommented:
Yes I do in sql you create a stored procedure to get all the fields that you need for the report including blob field

Then you create a dataset from that stored proc
Then you set that dataset as your report's datasource

Place the blob field from the dataset into your report to display the image

That is it
Regards
Emre
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
Oh ok.. If i'm followig  you correctly... I have a "system odbc"  that points to the stored procedure.  If that what you are referrring to.  I'm using CR 8.0  and its giving me "Not Supported".  Do think its the verions of CR that we are using?
0
ebolekCommented:
Yes exactly. Make your stored procedure get you all the fields .. Then create a dataset with that stored procedure. Then you are good to go .
0
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
That's where the problem arises... when i use a stored procedure as the datasource, CR 8.0 defines the image field as a "blob".  when i try to execute the report i get a blank screen that say's "Not Supported".
0
ebolekCommented:
the image is stored in db right
0
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
yes its stored in the db... not quite sure what you mean by "Then create a dataset with that stored procedure."  How do I create a "dataset" with the stored Procedure?  In CR 8.0 you can reference tables, and stored Proceudres.  where do you reference a dataset? what type is the dataset?  do you have an example of the code?
0
ebolekCommented:
I am using 10 and never used 8 with datasets. But what I do is , in .net I create a dataset and then drag and drop the stored procedure that I want from the server explorer on top of the dataset. That is what I mean

Regards

Emre
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.