Problems with images in report

[Former Member]

Hi, I have a report that uses a column of type image in an sql server mdf file.

The report design shows this as a blobobject.

When I try to print the image it is either too small or if I drag to a larger size the image is of very bad quality.

The image data from the database field comes from an image jpeg file of 825 x 3100 pixels.

If I set the blobobject to this the print is tiny but if I drag to a bigger size it is not good at all?

Any tips please?

This is my first try at printing image data!

[Former Member]

Hi Paul,

If you drag the picture more than it's size, it will loose its resolution. Try to keep the minimum size and go in FileReport Optionsand click on Retain Original Image Color Depth.

Thanks,

Sastry

[Former Member]

Hi, thank you for the quick reply!

The image is black and white so do not know if that will help?

It is more the size that is the issue?

If I just open the image with say MS PM and print it looks perfect but from CR it is small and tiny if I set the blob to the pixel size?

I see there is a scaling x and y but I dont understand those?

[Former Member]

Hi Paul,

It may be the problem with blob field, can you try to insert the image in Crystal and check the quality of the picture.

You can insert the image through Insert--Image or insert as OLE Object.

Thanks,

Sastry

[Former Member]

Hi,

when I drop the image direct it is clearly visible in design mode and is HUGE!

the height for example is 25221....!!

[Former Member]

So, there is some problem with your blob field. What is the datasource you are using ? Try to change datasource like ODBC,OLE DB or Native.

If you can insert the images directly then you can resize the image in design and right lick on the image and go in format picture --common --remove the Can Grow option.

Thanks,

Sastry

[Former Member]

Great help, really appreciate it!

The data is read from a column in an sql database file .mdf

The sql defintion in vb.net 2008 says it is of type IMAGE.

When I view the data in dataview it says it is <binary data>

I drag this field onto the report from Database Fields and it appears on the report as a IblobFieldObject with a puny size of 226 * 1440

What I need is the image data in the blob to look like the image when droped on the report uing the jpg file

[Former Member]

Hi Paul,

Try to change the datasource and check.

Thanks,

Sastry

[Former Member]

Hi,

sorry to sound dim...but all I have is:

Project Data -> ADO .NET datasets

and

Project Data -> .NET Objects

The ones you mention do not appear?