[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

sql server 2000 image fields not working

Posted on 2004-11-01
10
Medium Priority
?
297 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:Mike Johnson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 10

Expert Comment

by:ebolek
ID: 12463351
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
 

Author Comment

by:Mike Johnson
ID: 12463674
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
 
LVL 10

Expert Comment

by:ebolek
ID: 12463698
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
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

 

Author Comment

by:Mike Johnson
ID: 12463845
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
 
LVL 10

Expert Comment

by:ebolek
ID: 12463862
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
 

Author Comment

by:Mike Johnson
ID: 12465791
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
 
LVL 10

Expert Comment

by:ebolek
ID: 12465802
the image is stored in db right
0
 

Author Comment

by:Mike Johnson
ID: 12493734
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
 
LVL 10

Accepted Solution

by:
ebolek earned 375 total points
ID: 12495561
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question