Skip to Content

Load blob field from MySQL in crystal reports

Hi SAP users, good afternoon. As you may realize in the title of the question, this is the situation:

I have a blob field in my database that have the signature of each user in a system. Then, in certain reports, I place the signature depending the user in session.

Then, I try to show in the report dinamically the user.

My question is: How I can load the blob field in the report? I use MySQL

Thank you so much, have a nice day.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 04, 2019 at 08:02 PM

    Use a formula to link the field to the object where the signature is to be.

    The formula has the field with the OLE Object in it, I assume you can link it by ID of some sort to the user.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2019 at 02:02 PM

    If the blob is included in one of the tables in your report and the image is stored in a format that Crystal recognizes, you should be able to do this:

    1. Place an image object on your report, choosing a default image to use when there is not data in the blob field.

    2. Right-click on the image objects and select "Format Graphic..."

    3. Go to the Picture tab and click on the "Graphic Location" formula button.

    4. Add the blob field that the image is in to the formula.

    5. Click "Save and Close", then "OK".

    If Crystal is able to read the image from the blob field, you should now have the images in your report.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.