We have one field in the report.  It is a 'picture' type field.  It displays an image if the image exists in the database, otherwise blank. 

 

So, Crystal is displaying a blank image with a border around it.  How do I prevent this from displaying at all?  The field itself has all the border line styles set to None the Border color is set to black, but no borders should be printing at all, so the border color should not apply.

 

I don't understand why this is happening.

 

The subreport runs an SQL stored procedure.  We insert the results into a temp table.  One of the columns in the table is a bit field that will tell us whether or not rows were returned.

 

Well, rows were always getting returned even if the picture/blob/image field was blank.  Why?  The image is defined as a nullable image in the database, so it was always returning something because of the null value in the image.  So the rows returned was always true.  I needed to add an image is not null statement to the where clause in the stored procedure (or modify each subreport and add IsNull(image) to each image's suppress condition).  It was easier to modify one sql stored procedure.

 

Problem solved.  Although we never had this problem with our VB6 application...just with the .NET applications.