Solved

sql server 2000 image fields not working

Posted on 2004-11-01
288 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
Question by:Mike Johnson
    9 Comments
     
    LVL 10

    Expert Comment

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

    Author Comment

    by:Mike Johnson
    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
    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
    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
    the image is stored in db right
    0
     

    Author Comment

    by:Mike Johnson
    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:
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    934 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now