Load blob field from MySQL in crystal reports

[former_member603666]

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.

[former_member11696 · Accepted solution]

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.

[DellSC]

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.

-Dell

[former_member603666]

I try but a message show and the text is "you can´t use a blob field in a formula".

[DellSC]

You could just try putting the blob field on the report, then. If that doesn't work, then you may not be able to do this because Crystal won't recognize the field as an image.

-Dell