Show JPEG in Report

[Geri2]

Hi all,

I have a little problem, because I want to show an
JPEG in Crystal and I don't know how.
With BMP-Pictures it works fine but other datatyps not.

Can somebody help me?

Thank's in advance

Geri

 

[dgillz]

Is this a .jpg that is stored in the database as a blob field, or is this a stand alone .jpg you want to place at the top of the report, or what?

I just tested this in version 8.5 and it works fine.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Geri2]

hi,

the pic is stored in an folder on C:\, and yes, I want to place it on pageheader.

If I try to show it, I only see the symbol like (for example the Paint-Symbol) it shown in the folder but not the real pic (for example an ring).

How it works to store an pic in the database? I never do that befor!

(Crystalversion: Seagate Crystal Reports Pro Upgrade
Produkt: 8.0.1.0
CRW32 8.0.0.371)

Geri

 

[GJParker]

Geri

have you added this picture as an OLE Object ? try addin the image again and make sure the dusplay as icon check box is not ticked.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[dgillz]

If you are trying to display a static picture, just place it on the report as Gary suggested.

If this is a .jpg that varies for every record on the report, Crystal cannot do this as a stand alone tool. The image itself must be in the database as a blob field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[chelseatech]

To add a static picture to your report, use "Insert Picture" on the menu and select the file.

There are several potential reasons for it not appearing. JPG can be of varying quality. Use photoshop etc and see if you need to change any settings.

Another approach is to use the Windows XP Image resize tool and "Resize" for web. A large high quality image on a crystal report can look poor if resized within crystal.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Geri2]

Thanks you help me a lot!
With the WinXP-Image it works.

But I have also an question. How it works to store an pic in the database?
I don't understand that very much.

Thanks in advance

Geri

 

[dgillz]

If you make a field in your database a memo or blob field, then you can store the pic in that field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Geri2]

Thats ok, but I don't understand how to store the pic in the field.
If I make a field with the SQL Enterprise Manager I can't change the field.
I only know that I should insert binärydatas.
So could you explain me step by step how to make a Blobfield with a pic inserted.

Thanks

Geri

 

[dgillz]

You an't change the field? Or you cannot change the datatype of the field?

I have used MS Access as a front end to load the pics into a memo field in MS SQL Server. However I did not design the Access app and this question is best asked in another forum, perhaps one of the MS SQL forums.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[Geri2]

Ok, but thanks a lot.
You really help me.
Have a nice day.

Geri